Master Data Management
2 posters
Page 1 of 1
Master Data Management
Hi All,
I think more organizations (with disparate systems) are beginning to realize the need to address the issue of having a standardize master data repository before embarking on a DW project. Different vendors have different ideas about implementing MDM (esp. with SOA). I am just wondering while there is definitely a need to have common repository to house all these master data, but is it advisable to implement them as dimensional tables? Or in a more convensional method to store this master tables (outside DW)?
Anyone with such experiences, please enlightened my thoughts...
Cheer,
Mark
I think more organizations (with disparate systems) are beginning to realize the need to address the issue of having a standardize master data repository before embarking on a DW project. Different vendors have different ideas about implementing MDM (esp. with SOA). I am just wondering while there is definitely a need to have common repository to house all these master data, but is it advisable to implement them as dimensional tables? Or in a more convensional method to store this master tables (outside DW)?
Anyone with such experiences, please enlightened my thoughts...
Cheer,
Mark
mark.tan- Posts : 14
Join date : 2009-02-04
Re: Master Data Management
You don't need a MDM repository to do a data warehouse. You don't need a MDM repository period. The vast majority of companies manage to make large sums of profit each year with redundant data stores stuffed full of inconsistent data. I would not implement a dimensional data structure to support a MDM repository. The MDM access paths are more like the typical OLTP access paths than a standard dimensional query. You certainly can source a dimension from a MDM repository though. Life in the data warehouse would clearly be easier with a MDM repository in place.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Master Data and Dimension location
» Modeling tool with support for hierarchies
» metadata management
» Accumulating Snapshot Fact Table Data Model (Order Management)
» Merging customer data from disparate sources to create a master customer dimension
» Modeling tool with support for hierarchies
» metadata management
» Accumulating Snapshot Fact Table Data Model (Order Management)
» Merging customer data from disparate sources to create a master customer dimension
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum