The
steps are,
- Compare record counts between data sources
- Ensure that the ETL application properly rejects, replaces with default values and reports invalid data
- Verify that data is transformed correctly according to system requirements and business rules
- Compare unique values of key fields between source data and warehouse data
- Ensure that all projected data is loaded into the data warehouse without any data loss or truncation
- Test the boundaries of each field to find any database limitations
No comments:
Post a Comment