Wednesday, 9 January 2013

Data Validation Testing Phase in ETL Testing

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

Related Posts Plugin for WordPress, Blogger...

ShareThis