What is ETL process in Data warehousing?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the data types present in bo? What happens if we implement view in the designer n report?

544


What are the advantages of cold fusion?

530


Can we start and stop single session in concurent bstch?

528


Explain the difference between keylokup and joiner?

501


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5470






Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

503


In a star schema, are foreign key constraints between facts and dimensions neccessary?

542


What are the tools available for etl?

544


What are data validation strategies for data mart validation after loading process?

535


Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

518


Could any one explain me how to create cascading prompts?

509


Explain about core dimension, balanced dimension, and dirty dimension?

560


Do you view contain data?

558


How to get the first 100 rows from the flat file into the target?

682


How to drill through from a powerplay cube to reportnet?

502