Testing the Data Warehouse Practicum: Assuring Data Content, Data Structures and Quality

The quality of a data warehouse (DWH) is the elusive aspect of it, not because it is hard to achieve [once we agree what it is], but because it is difficult to describe. We propose the notion that quality is not an attribute or a feature that a product has to possess, but rather a relationship between that product and each and every stakeholder. More specifically, the relationship between the software quality and the organization that produces the products is explored. Quality of data that populates the DWH is the main concern of the book, therefore we propose a definition for data quality as: “fitness to serve each and every purpose”. Methods are proposed throughout the book to help readers achieve data warehouse quality.