ETL Validator gives quick and easy way to create test cases for comparing counts and measures of source & target data sources. A variance can be specified too.
Here, we will create a Checksum test case that will compare measures and counts. The same functionality is also implemented in Component test case using 'Measure Validation'. The slideshow below walks you through creating the test case.
ETL Validator Usecase - Validating Measures, Counts with Variance