What are the BEST ways of Datawarehouse Testing?
Following are few Best Ways for Datawarehouse testing.
Data Reconciliation: Comparing the data at attribute level writing queries (SQL) codes to compare the counts between the source and traget to start with. Later to check the data to bechmark the desired Data Quality for the transformed /migrated Data.
Sampling: Sampling is another way of testing the DWH. Taking samples of the Data.
Regression Testing: Datawarehouse tend to grow ove a course of time its a good practice to have Regression testing as a part of each release.
This Blog covers the areas covered under Business Intelligence. Powered by experienced BI Professionals
Please can you add more information on Sampling
ReplyDeleteSample testing is analogus to unit testing during development. But in Sample testing its prudent to take new set of sample data in the Test environment.
ReplyDeleteEg: If you are testing a Retail banking DWH. You should take few Customer Account Numbers and test the expected results against them.
Sample testing is more practical if Reconciliation scripts are difficult to write.