O'Reilly logo

Designing a Data Warehouse: Supporting Customer Relationship Management by Chris Todman

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. The Physical Implementation

In this chapter, we will explore ways to create the physical data warehouse. There is a traditional left to right flow of data from the source systems to the warehouse. The operational process begins by the periodic extraction of data. The data has to be tested for quality. The quality of data is a major headache for most data warehouse developers, and we will be exploring this issue in some depth. Poor data quality will threaten the success of the whole project.

Also, we need to consider what happens to the warehouse when changes occur in the source systems. Changes can be very slight, having little or no impact, or they can be massive, as in the case of the introduction of a new enterprise resource planning ...

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