Record Management & Survivorship Rules for ETL

A central goal of Master Data Management (MDM) is achieving a single source of truth – one record that captures all the pertinent information we need about a customer, resource, product or service – that is 100% accurate. However, working with multiple databases and disparate entry points for data makes the creation of duplicate records from incomplete entries, changes that occur over time, or other reasons likely and achieving a Golden Record a difficult challenge.

Enter MatchUp to the rescue.

Data Matching - Building the Golden Record

Building the Golden Record

MatchUp’s Golden Record Selection options for SSIS and Pentaho allow for the intelligent selection of the Golden Record from a group of duplicates to create a single, accurate and complete version of each customer record.

MatchUp can identify the best record of a matched group based on virtually unlimited criteria including:

  • Data Quality Score (most accurate address, name, phone, and/or email address)
  • Last Updated
  • Most Complete
  • Custom Expression

Ready to Get Started?

Let’s Talk

Improve the quality of your customer data today.

Contact us
Explore the API

Discover Melissa APIs, sample code & documentation.

Learn more
Try Listware

Use our Online data cleansing app or plugin for Excel.

Start for free
Use our Service Bureau

Full-service data processing to clean, dedupe & enrich.

Send us your file

Helpful Resources

Video

Data Matching / MatchUp Video

Watch Video
Webinar

Video

Watch now
Whitepaper

Golden Records Whitepaper

Read Now
Ready to Start Your Demo?

Start today with Melissa's wide range of Data Quality Solutions, Tools, and Support.

Schedule a Demo