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 ...
Get Designing a Data Warehouse: Supporting Customer Relationship Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
