ETL Testing Online Training | ETL Testing Training for Beginners

This site requires Adobe Flash Player on your browser.
Please install Adobe Flash Player from here.

Uploaded by: BigOnlineTraining
on Tue, 23 Feb 2016 14:11:11 IST
 

ETL Testing Course Info : http://goo.gl/CTsYD6 ETL stands for Extract Transformation and Load, I... Show more

ETL Testing Course Info : http://goo.gl/CTsYD6

ETL stands for Extract Transformation and Load, It collect the different source data from Heterogeneous System and Transform the data into Data warehouse.

At the Time of Transformation, Data will first transforms to the Staging Table.

Based on Business rules the data is mapped into target table, this process manually mapped and configured using ETL Tool

ETL will not transforms the Duplicate data

The speed of Data Transformation process will be based on the Source and Target Data ware House.

We need to consider the OLAP (Online Analytic Processing) Structure as Data warehouse Model Source data consists of XML,Flat file.

We need to set the validation at time of data transformation like 'Avoid the 'NULL' values in the table,

validate the data type as using Tiny int instead of integer .etc

Based on the user requirement, ETL process starts.  Show less

Click here for Embed Code
  Embed: Hide

Comments