What is ETL process in Data warehousing?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to limit the max no of rows retrieved in the report?

551


How to design file watch jobs?

579


How do you create surrogate key using ab initio?

545


What are the different types of segments?

546


hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

1642






List any five applications of data warehouse.

550


Explain what are the different types of join operations?

535


What according to you might be the future of data warehousing?

528


Explain what are the advantages of query studio compared to report studio?

546


How to handle multi value dimensions?

1781


Describe the differences between a data warehouse and data mart.

504


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?

571


What is the goal of optimizer?

586


What are the tools available for etl?

544


What is core dimension?

548