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, ...
Get Data Warehousing: Architecture and Implementation 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.
