ETL Testing Training
Total number of Students in course0
Students Currently taking this course
ETL Testing Training Events
|‹ Jun||Aug ›|
ETL Testing Training
ETL TESTING TRAINING: ETL stands for Extract Transformation and Load, It collect the different source data from Heterogeneous System (DB), …
ETL TESTING TRAINING:
ETL stands for Extract Transformation and Load, It collect the different source data from Heterogeneous System (DB), Transform the data into Data warehouse (Target)
ETL refers to Extracting, Transforming and Loading of Data from any outside system to the required place.ETL Testing training helps understanding the business structure and their particular requirement.
At the Time of Transformation, Data are first transform to Staging Table (temporary table)
Based on Business rules the data are mapped into target table, this process are manually mapped / we configure using ETL Testing training Tool
ETL not transformed the Duplicate data
Data Transformation process speed based on Source and Target Data ware House
We need to consider the OLAP(Online Analytic Processing) Structure .Data warehouse Model
Source data consist of (XML,Flat file ,Database.Excel Report.Dataware House
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
ETL Testing training course will cover following topics:- Introduction to ETL testing and OLTP vs. OLAP, -Introduction to RDBMS & Database Testing Vs Data warehouse Testing, Data Warehouse Workflow & Case Study, Data Checks using SQL, Scope of BI testing.
This course is designed for beginners to advance level professionals.
Basic Knowledge of SQL
Business Intelligence Professionals or ETL Developers
Professionals aspire to become Business Object Professionals
Project Managers, Database Professionals, Mainframe Professionals, SQL Developers
The ETL Testing Methodology includes following steps:
- Understanding of data to be reported
- Understanding and review of data model
- Understanding2 and review of source to target mappings (transformations)
- Data Quality Assessment of Source data
- Packages testing
- Schema testing (source and target)
- Verify Data completeness
- Verification of transformation rules
- Comparison of sample data between source and target
- Checking of referential integrities and relations (primary key foreign key)
- Data Quality checks on target warehouse
- Performance tests
No Reviews found for this course.
At the end of the course there will be a quiz and project assignments once you complete them you will be awarded.