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


Data Matching / MatchUp Video

Watch Video


Watch now

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