What are some best practice approaches such as:

  • SCD type 1/2/3
  • nulls
  • duplicates
  • missing data
  • extra data
  • special characters
  • FK/PK referential integrity.etc

2 Answers 2


I believe this article gives a good overview of the different data warehouse testing that should be applied: http://quality-gates.com/?p=1284 We are using this method in almost every data warehouse project.

  • 1
    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
    Commented Oct 11, 2013 at 20:15

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: http://msdn.microsoft.com/en-us/library/gg261774.aspx.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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