O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 7 Data Quality

The data warehouse is expected to be the authority for any data it provides. To gain and maintain this position of authority, a data warehouse should only contain data that is complete, correct, and consistent. If you are the manager of the data warehouse, you may not be responsible for the quality of data sources, but you are responsible for ensuring that only quality data reaches the data warehouse.

It seems that regardless of how much care is taken with an OLTP database, data quality issues arise when data reaches the data warehouse. When your data warehouse is receiving data from a multitude of independently managed sources, problems are compounded. Data “managed” locally by users is often deemed good by them, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required