DBA > Job Interview Questions > Data Warehousing Interview Questions and Answers

What is ETL?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is ETL?

ETL stands for extraction, transformation and loading.

ETL provide developers with an interface for designing source-to-target mappings, ransformation and job control parameter.
Extraction
Take data from an external source and move it to the warehouse pre-processor database.
Transformation
Transform data task allows point-to-point generating, modifying and transforming data.
Loading
Load data task adds records to a database table in a warehouse.

(Continued on next question...)

Other Job Interview Questions