x
Menu

ETL Testing

Other,

Overview

Includes

Lecture 1:

4.1 ( 11 )


Lecture Details

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.

Ratings

4.5


2 Ratings
55%
30%
10%
3%
2%
Comments
comment person image

Sam

Excellent course helped me understand topic that i couldn't while attendinfg my college.

Reply
comment person image

Dembe

Great course. Thank you very much.

Reply
Send