O'Reilly logo

Data Warehousing: Architecture and Implementation by Michelle C. Dy, Michael W. Hawkins, Mark Humphries

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 15. Warehouse Maintenance and Evolution

With the data warehouse in production, the warehousing team will face a new set of challenges—the maintenance and evolution of the warehouse.

Regular Warehous Loads

New or updated data must be loaded regularly from the source systems into the data warehouse to ensure that the latest data are available to warehouse users. This loading is typically conducted during the evenings, when the operational systems can be taken offline. Each step in the back-end process—extract, transform, quality assure, and load—must be performed for each warehouse load.

New warehouse loads imply the need to calculate and populate aggregate tables with new records. In cases where the data warehouse feeds one or more data marts, ...

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