Take the 2-minute tour ×
Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It's 100% free, no registration required.

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
add comment

1 Answer 1

[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
add comment

Your Answer

 
discard

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.