Informatica Interview Question and Answers
| 6. |
What are ETL Tools? |
| |
ETL Tools are stands for Extraction, Transformation, and Loading the data into the data warehouse for decision making. ETL refers to the methods involved in accessing and manipulating source data and loading it into target database. |
| |
|
| 7. |
What are Dimensional table? |
| |
Dimension tables contain attributes that describe fact records in the fact table. |
| |
|
| 8. |
What is data Modelling? |
| |
Data Modeling is representing the real world set of data structures or entities and their relationship in their of data models, required for a database.Data Modelling consists of various types like : - Conceptual data modeling
- Logical data modeling
- Physical data modeling
- Enterprise data modeling
- Relation data modeling
- Dimensional data modeling.
|
| |
|
| 9. |
What is Surrogate key? |
| |
Surrogate key is a substitution for the natural primary key. It is just a unique identifier or number of each row that can be used for the primary key to the table. |
| |
| Ramakrishna,said |
Apr 21, 2014 |
|
The Primary Key of the data whcih is stored into the DW that is called Surroagate Key.
|
|
| 10. |
What is Data Mining? |
| |
A Data Mining is the process of analyzing data from different perpectives and summarizing it into useful information. |
| |
|
Gk Questions with Answers