Dear All,
Would like to put forward this question as well:
Our company has a datawarehouse and we have merged with a new company that does not have a datawarehouse and now we are to combine/merge the new company's data into our existing datawarehouse.
I would like to know from everyone in this forum on what are the areas and issues/aspects of consideration in preparing for this merging activity.
Thanks in advance.
Datawarehouse's Data Merging Considerations
Moderators: chulett, rschirm, roy
For that you need to get your data modeler/data architect involved. Lay out a rough sketch of how the data is combinable. Handle cons, create extra tables for different/new dimensions, create fact/factless fact tables, or add new attributes to the existing tables.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Look also for opportunities to use conformed dimensions. For example, typically the same time granularity will be used regardless of data source, so that the same time dimension table can be used with all fact tables.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You should also consider a master data management process. For example, where is your definitive list of customers, addresses and products? Are you decommissioning core systems? You could try and make your data warehouse the consolidated view of all information from each set of systems but you face a difficult matching, consolidation and deduplication task as you populate the DW.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: