Subscribe to this video course and get access to Etl Testing Training Videos tutorials till  2016-05-31

 ETL is a software that mainly targets the idendity and reduction of existing data defects and general errors occuring prior to processing of data for analytics and reporting.

 

ETL Testing Methodology includes following steps:

1. Understanding of data to be reported
2. Understanding and review of data model
3. Understanding and review of source  to target mappings (transformations)
4. Data Quality Assessment of Source data
5. Packages testing
6. Schema testing (source and target)
7. Verify Data completeness
8. Verification of transformation rules
9. Comparison of sample data between source and target
10. Checking of referential integrities and relations (primary key foreign key)
11. Data Quality checks on target warehouse
12. Performance tests