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.

No comments:

Post a Comment