Operational Data Store (ODS):Data Warehousing (DWH):Enterprise Data Warehouse (EDW)

DWH Concepts and Fundamentals


Operational Data Store (ODS) : - Staging Area. Data updated from ERP etc.

Data Warehousing (DWH) : Data from Staging Area loaded for data storage.

Enterprise Data Warehouse (EDW) : Data Sources from different Business Area updating data (Data Marts etc.) [ If clear pictures of Business processes are known , then this is having integrated data.]