Added to favorite list
Updated On 02 Feb, 19
4.1 ( 11 )
ETL Testing Course Info httpgoo.glRFFSOC
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.
Sep 12, 2018
Excellent course helped me understand topic that i couldn't while attendinfg my college.
March 29, 2019
Great course. Thank you very much.