DataWarehouse and Data Marts

Data Warehouse (Top – down approach)

• -          Union of all the data mart
• -          Data Received from staging area
• -          Corporate enterprise wide data
• -          Data Received from staging area

Data Marts (Bottom up approach)

• -          Departmental view of data
• -          Star Join (Facts and Dimension)
• -          A single business process