|
|
| Line 1: |
Line 1: |
| [[SSIS:Reference|← SSIS Reference]]
| | {{SSISMatchUpNav |
| | | |MatchUpTabsCollapse= |
| {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
| | }} |
| ! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''MatchUp Navigation'''
| |
| |-
| |
| | style="padding-right:220px;"|
| |
| |-
| |
| |[[SSIS:MatchUp|Overview]]
| |
| |-
| |
| |[[SSIS:MatchUp Tutorial|Tutorial]]
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black;"|[[SSIS:MatchUp:Advanced Configuration|Advanced Configuration]]
| |
| |-
| |
| |[[SSIS:MatchUp:Advanced Configuration#On-Premise|On-Premise]]
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black;"|MatchUp Tabs
| |
| |-
| |
| |[[SSIS:MatchUp:Matchcode|Matchcode]]
| |
| |-
| |
| |[[SSIS:MatchUp:Field Mapping|Field Mapping]]
| |
| |-
| |
| |[[SSIS:MatchUp:Options|Options]]
| |
| |-
| |
| |[[SSIS:MatchUp:Golden Record|Golden Record]]
| |
| |-
| |
| |[[SSIS:MatchUp:Survivorship Pass-Through|Survivorship/Pass-Through]]
| |
| |-
| |
| |[[SSIS:MatchUp:Lookup Pass-Through|Lookup Pass-Through Columns]]
| |
| |-
| |
| |[[SSIS:MatchUp:Output Filter|Output Filter]]
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;" | |
| |- align="left"
| |
| ! style="color:black;"|[[SSIS:MatchUp:Matchcode Editor|Matchcode Editor]]
| |
| |-
| |
| |[[SSIS:MatchUp:Matchcode List|Matchcode List]]
| |
| |-
| |
| |[[SSIS:MatchUp:Component List|Component List]]
| |
| |-
| |
| |[[SSIS:MatchUp:Component Properties|Component Properties]]
| |
| |-
| |
| |[[SSIS:MatchUp:Algorithms|Algorithms]]
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;" | |
| |- align="left" | |
| ! style="color:black;"|[[SSIS:MatchUp:Matchcodes:Overview|Matchcodes Overview]]
| |
| |-
| |
| |[[SSIS:MatchUp:Matchcodes:Component Combinations|Component Combinations]]
| |
| |-
| |
| |[[SSIS:MatchUp:Matchcodes:Blank Field Mapping|Blank Field Mapping]]
| |
| |-
| |
| |[[SSIS:MatchUp:Matchcodes:Mapping|Mapping]]
| |
| |-
| |
| |[[SSIS:MatchUp:Matchcodes:Optimization|Optimization]]
| |
| |-
| |
| |[[SSIS:MatchUp:Matchcodes:Swap Matching|Swap Matching]]
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black;"|[[SSIS:MatchUp:Result Codes|Result Codes]]
| |
| |-
| |
| |[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
| |
| |-
| |
| |[[Result Codes]]
| |
| |}
| |
| |}
| |
|
| |
|
| {{CustomTOC}} | | {{CustomTOC}} |
← SSIS:Data Quality Components
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.
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.
For more information on the Matchcode Editor, see Matchcode Editor.