SSIS:MatchUp:Matchcode

From Melissa Data Wiki
Jump to navigation Jump to search

← SSIS:Data Quality Components

MatchUp Navigation
Overview
Editions
Tutorial
Advanced Configuration
On-Premise
MatchUp Tabs
Matchcode
Field Mapping
Options
Golden Record
Custom Expression Elements
Survivorship/Pass-Through
Lookup Pass-Through Columns
Output Filter
Matchcode Editor
Matchcode Evaluation
Matchcode List
Component List
Component Properties
Algorithms
Matchcodes Overview
Component Combinations
Blank Field Mapping
Mapping
Optimization
Swap Matching
Result Codes
Result Codes



Matchcodes are sets of rules that tell MatchUp component which data fields to consider when determining if two records are duplicates. MatchUp component uses the matchcode to construct a "match key," a simplified string of characters that represents the information within the record, enough to determine if the given records is unique or a duplicate.


SSIS MU Matchcode.png


If you would like to copy and edit one of these default matching strategies, or create a new matchcode from scratch, select File from the menu and click Matchcode Editor.


SSIS MU Menu.png


For more information on the Matchcode Editor, see Matchcode Editor.