A friend sent me an article about tools for testing a data warehouse. The article supports the concept of Embedded Quality. You can read the full article here.

My favorite quote is, "In DW, as in every other IT discipline, testing — early and often — is of paramount importance. For a variety of reasons, however, DW testing windows are often compressed — while comprehensive testing is itself impossible. If testing is done, it’s often performed after the fact — when the data warehouse is exposed to end users. This is a bad idea on several levels, experts say, because it undermines confidence in the service at precisely the point when confidence is most important."