Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

Failover Clustering in the Cloud - Understanding Your Options - Free Webinar

Easy to use Data Matching and Cleansing Solution for SQL Server

Sponsored by - Melissa

Whitepaper Abstract

On average, a database contains 8-10% duplicate records. These duplicates result in waste and inefficiencies that cloud your ability to get a single, accurate view of the customer.

Use Melissa MatchUp® to quickly find and link customer data, consolidate data across multiple sources and remove unwanted business and customer records – quickly and easily improving master data management, data warehousing and business intelligence, as well as marketing and mailing efficiency.

Combines data parsing, matching and consolidation to eliminate clutter and duplicates that prevent a clear view of your customers.

MatchUp was designed around a heuristic-based approach with the aim to resolve customer and contact data quality issues by increasing the identification of duplicate records while minimizing false matches or minimizing matches between genuinely unique records. MatchUp includes proprietary and standard algorithms to detect phonetic, fuzzy, miskeyed, and abbreviated variations, combined with deep domain knowledge of names, including nicknames and multicultural name variations, and international addresses.

Technical Information

MatchUp provides easy integration into your applications and databases.

Format: PDF

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

More SQL Server Solutions

Learn more about SQL Server tools