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.
Another specific of Datawarehouses is the need to monitor the dataqaulity on a daily basis on production system.
What kind of test should be performed for a datawarehouse and which tools can be used to support you and to automate the testing