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.

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
share|improve this question
    
Please check related question sqa.stackexchange.com/questions/1212/… –  Siva Sep 30 '11 at 3:21
add comment

2 Answers

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

share|improve this answer
add comment

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.

share|improve this answer
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 Oct 11 '13 at 20:15
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.