What is ETL process in Data warehousing?
Answers were Sorted based on User's Feedback
Answer / siri
ETL means extraction,transformation and loading.i.e
extracting the data from different data bases and
transforming it depending on our requirements then finally
load it into warehouse.
| Is This Answer Correct ? | 50 Yes | 4 No |
Answer / ramjanaki
ETL Process can be defined as the Extraction of Information
from various sources like flat files, databases or XML
data, Performing transformations (manipulations on the data)
based on the user requirements and loading them to the
Target location.
| Is This Answer Correct ? | 29 Yes | 3 No |
Answer / ravi rajak
ETL means extraction,transformation and loading.It means extracting the data from the heterogeneous sources and after that transform that data into same format is transformation and and then we load that data into the datawarehouse is loading.
| Is This Answer Correct ? | 7 Yes | 6 No |
What a static and local variable?
What is normalization, first normal form, second normal form, third normal form?
What is a linked cube?
What is cfapplication tag?
When should one use an MD-database (multi-dimensional database) and not a relational one?
What is conformed fact?
1.WHAT IS DATA MART ?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
How many ways we test the universe & Report?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What is a fact table?
in general which algorithms for used?