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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
[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.