data warehouse testing checklist

Question

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

Answer 1

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