More DBA job interview questions and answers at
(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.
Take data from an external source and move it to the warehouse pre-processor database.
Transform data task allows point-to-point generating, modifying and transforming data.
Load data task adds records to a database table in a warehouse.
(Continued on next question...)