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

what are some best practice approaches such as:

SCD type 1/2/3
missing data
extra data
special characters
FK/PK referential integrity.etc
share|improve this question
Please check related question… – Siva Sep 30 '11 at 3:21

I found this to be a useful, though high level article about data validation. It's more about how to approach the testing than specific tests, but it does contain some specific tests and has a lot of useful information:

share|improve this answer

I believe this article gives a good overview of the different data warehouse testing that should be applied: We are using this method in almost every data warehouse project.

share|improve this answer
Welcome to SQA, uzi. Could you provide a short summary of the method provided in the link, and where applicable, provide your personal experience and how you interpreted the method? – corsiKa Oct 11 '13 at 20:15

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.