Thursday, 25 October 2012

What is ETL? | ETL Testing Interview Questions

 ETL stands for extraction, transformation and loading
ETL provide developers with an interface for designing source-to-target mappings, transformation 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.

No comments: