Thursday, March 21, 2013
Data Warehouse Architecture (with a Staging Area)
You need to clean and process your operational data before putting it into the warehouse. You can do this programmatically, although most data warehouses use a staging area instead. A staging area simplifies building summaries and general warehouse management.
Figure 1-3 illustrates this typical architecture.