If regularly testing the creation of different datawarehouse tables using mappings from source tables. What do you suggest is the best approach or specific SQLs to do the trick?
[Disclaimer: This product is created by my company]
We have a product call QuerySurge that allows you to fully compare data in the source tables with the data loaded into the data warehouse. Compared to other approaches, this seems to be the best automated method for validation.