Data Warehouse Architecture (with a Staging Area)

We need to clean and process our operational data before putting it into the warehouse. So we can do this programmatically, although most data warehouses use a staging area instead. A staging area simplifies building summaries and normal data warehouse management