Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Hi toop, welcome to SQA. You asked a broad question. I suggest you type "data warehouse" into the search box in the upper right-hand corner of this page, hit the "Enter" key, and read some of the questions and answers listed in the search results. After that, if you have a more specific question, feel free to ask it. – user246 Nov 3 '11 at 15:16

[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.

share|improve this answer
I haven't used QuerySurge, but if it does half of what it claims, it would be a VERY useful tool for data warehouse testing. – Bruce McLeod Feb 3 '12 at 21:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.