Identify and eliminate obvious and not-so-obvious duplicate records

MatchUp Component for SQL Server Integration Services (SSIS) is an extremely fast and powerful tool that is used to find and eliminate duplicate records, specifically in the contact record domain. MatchUp enhances the efficiency and effectiveness of your database by giving you the ability to eliminate duplicated customer and prospect records with user specified customizable criteria to realize a single, accurate view of each customer.

Identifying Duplicates – From Obvious to Not So Obvious
MatchUp's advanced fuzzy matching algorithms can identify obvious duplicates like:

MatchUp Component for SSIS - Obvious Duplicate Match Example

And not-so-obvious duplicates like:

MatchUp Component for SSIS - Not Obvious Duplicate Match Example

Create Your Own MatchCodes
With MatchUp you can set up your own matching rules (called Matchcodes) in any combination of over 35 components from common ones like Zip Code, Address, and Last Name – to not-so-common elements like Email Address, Company, and Social Security Number. You can even specify your own proprietary data component, such as an account number, using the user-interface-driven MatchCode editor.

MatchUp Component - MatchCode Editor Example

Post processing with MatchUp, each unique group of identified duplicates to have 1 record which receives an “unique” status; while the other matching records receive a “duplicate” status.

MatchUp Component - Batch and Incremental Modes Example

System Requirements
Data Quality Components for SSIS are 32/64 bit tools available for Windows XP/2003/2008/Vista/7 and Microsoft SQL Server 2005/2008

Minimum Requirements (Not Recommended)
·         32-Bit Windows XP/2003/2008/Vista/7
·         Microsoft SQL Server 2005/2008
·         6 GB hard-disk space

Recommended Requirements
·         64-Bit Windows XP/2003/2008/Vista/7
·         Microsoft SQL Server 2008 R2
·         6 GB hard-disk space