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.