Master Data Management

View previous topic View next topic Go down

Master Data Management

Post  mark.tan on Thu Apr 23, 2009 5:53 am

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
avatar
mark.tan

Posts : 14
Join date : 2009-02-04

View user profile

Back to top Go down

Re: Master Data Management

Post  BoxesAndLines on Thu Apr 23, 2009 8:07 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum