Difference between revisions of "SSIS:MatchUp:Matchcodes:Overview"

From Melissa Data Wiki
Jump to navigation Jump to search
(Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa...")
 
Line 28: Line 28:
|-
|-
|[[SSIS:MatchUp:Options|Options]]
|[[SSIS:MatchUp:Options|Options]]
|-
|[[SSIS:MatchUp:Golden Record|Golden Record]]
|-
|-
|[[SSIS:MatchUp:Survivorship Pass-Through|Survivorship/Pass-Through]]
|[[SSIS:MatchUp:Survivorship Pass-Through|Survivorship/Pass-Through]]

Revision as of 22:09, 21 November 2014

← SSIS Reference

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


Matchcodes are sets of rules that tell the MatchUp Component which data fields to consider when determining if two records are duplicates. The 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 record is unique or a duplicate.