Testing is becoming more common for databases. However the focus of these test are mostly on Stored Procedures.
Datawarehouses and reporting solutions uses databases in a much different way. Testing is as important as for stored procedures but less simple. And not to forget Cubes!
Another specific of Datawarehouses is the need to monitor the dataquality on a daily basis on production system.
I will take you on the journey on the tools I use for testing a datawarehouse, including good old Excel, WinMerge and the relatively new kid on the block tSQLt.
The testframework tSQLt is very usefull for testing which some minor adaptions.
When there are cubes available in the Datawarehouse they can easily be used for regressing testing which is automated with tSQLt.
Last but not least I want to share some thougths how to test de reporting part of the datawarehouse