Data flow to EDW
2 posters
Page 1 of 1
Data flow to EDW
We have Integrated Data Repository that integrates the most recent data from different source. Data in IDR then will be loaded to EDW.
The question becomes that
1-one of the sources already provides history, should we load just the recent one on IDR and then again into EDW.
2-Since the normal data flow is from source to IDR then EDW, should we also load source directly to the EDW , like in the case above.
Regards
The question becomes that
1-one of the sources already provides history, should we load just the recent one on IDR and then again into EDW.
2-Since the normal data flow is from source to IDR then EDW, should we also load source directly to the EDW , like in the case above.
Regards
dshams- Posts : 13
Join date : 2010-12-08
Re:Data flow to EDW
Your IDR sounds like a staging area. If you are not facing data delivery latency, then you should follow normal data flow.
zoom- Posts : 97
Join date : 2010-08-23
Location : Chicago
Similar topics
» difference between data mart and data warehouse at logical/physical level
» Modelling an Event Flow
» Reporting table data repository vs. Dimensional data store
» star schema for process flow
» Is it a best practice that Data warehouse follows the source system data type?
» Modelling an Event Flow
» Reporting table data repository vs. Dimensional data store
» star schema for process flow
» Is it a best practice that Data warehouse follows the source system data type?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum