DataStages_Real_Time _Scenarios_ with Screen Shots_and _Solution

Friday, May 30, 2014

Architecture ODS Model


ETL-ODS Model




end-to-end data warehouse system data flow (ETL – Extract, Transform & Load). The first step (Extract) shows the process of extracting data from different data sources and consolidating into one centralized database (ODS). Source represents same data structure implemented in multiple instances, each local instance holds a different set of data (e.g.:  separated DB for each subsidiary/customer). Source represents an enterprise OLTP system DB (e.g.: global ERP, CRM, etc.)






No comments:

Post a Comment