This discussion is archived
2 Replies Latest reply: Sep 19, 2012 4:30 PM by 963198 RSS

Effectively managing master data from different sources

942536 Newbie
Currently Being Moderated
How does master data get managed effectively when it comes from different sources such as tools, vendors, and applications? I'm just looking into MDM for a project - we do not have anything in place yet.
  • 1. Re: Effectively managing master data from different sources
    mk_dba Explorer
    Currently Being Moderated
    Business rules must be defined by data owner and data validation, transformation and cleansing must be done by ETL and data quality tools during ETL and data load.
  • 2. Re: Effectively managing master data from different sources
    963198 Newbie
    Currently Being Moderated
    Any MDM tool should have minimum - data quality, data governance, services to receive and publish data, components/toolset to load data and survivorship rules.

    Data quality tool in general separate that needs to be integrated to MDM application. batch data and real-time data are sent to data quality tool. it cleanses, matches and send data to MDM application. MDM application reconcile data using survivorship rules. You can configure survivorship rules so that most confident source takes precedence when merging - auto merge.
    Most of MDM applications use web services to integrate source/participant applications..

    Need more info?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points