The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.

Question

Quizplus · Accepted Answer

The hub-and-spoke data warehouse model is a type of architecture that uses a centralized warehouse (the hub) to feed dependent data marts (the spokes). The central warehouse contains all the data from various sources and is responsible for data integration, while the data marts represent specific business units or areas and contain a subset of the data. The model is designed to improve data consistency and reduce redundancy by having a single version of the truth in the central warehouse.

The Hub-And-Spoke Data Warehouse Model Uses a Centralized Warehouse Feeding