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 are the methodologies of data warehousing?
What is the main difference between star and snowflake star schema? Which one is better and why?
What is called data cleaning?
What is confirmed dimension?
What are the vaious etl tools in the market?
What is the difference between er modeling and dimensional modeling?
Explain what are the modules in power mart?
Explain clustering algorithm?
Explain why should you put your data warehouse on a different system than your oltp system?
Why should we use data ware housing and how can you extract data for analysis with example?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
How do we design a universe?