ETL Testing : Trends
Count Validation
- Record Count Verification DWH backend/Reporting queries against source and target as a initial check.
Dimensional Validation
Data integrity between the various source tables and relationships. Also we should test the slowly changing dimension as given below. The most common slowly changing dimensions are Types 1, 2, and 3.
