Data Warehouse Architecture (with a Staging Area and Data Marts)

Data Warehouse Architecture (with a Staging Area and Data Marts)




•Data Sources (operational systems and flat files)
•Staging Area (where data sources go before the warehouse)
•Warehouse (metadata, summary data, and raw data)
•Data Marts (purchasing, sales, and inventory)
•Users (analysis, reporting, and mining