ETL Testing Tutorials For Beginners - Part 2 |
Title : ETL Testing Tutorials For Beginners - Part 2
Duration : 14:09
Channel : BigClasses.com
Label : etl testing tutorials for beginners, etl testing tutorials, etl testing videos, etl testing concepts, etl testing online training, etl testing training videos, etl testing informatica, etl testing automation, etl testing tools, etl dwh testing, etl testing video tutorials, etl testing online course
Duration : 14:09
Channel : BigClasses.com
Label : etl testing tutorials for beginners, etl testing tutorials, etl testing videos, etl testing concepts, etl testing online training, etl testing training videos, etl testing informatica, etl testing automation, etl testing tools, etl dwh testing, etl testing video tutorials, etl testing online course
ETL Testing Tutorials For Beginners - Part 2 |
ETL Testing Course Info : http://goo.gl/RFFSOC 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.