Often, as part of our testing, we want to be able to compare data in two tables or output of two queries between source and target system.
This deck explains how to do that using ETL Validator.
This Youtube Video shows the creation of the same test case.