I usually do an extract from the source, extract from the target and then difef the two. Or you can data-link in Excel to create and import two sets of the same data (source & target), and then use an Excel formula to compare the result sets.
Ive tested data warehouses like this with a lot of success.
This website takes effort, time and money to maintain. If you choose not to become a Prime member, but still would like to support my efforts, please feel free to donate what you find appropriate.