|
|
| (One intermediate revision by the same user not shown) |
| Line 1: |
Line 1: |
| [[SSIS:Reference|← SSIS Reference]]
| | {{SSISMatchUpNav |
| | | |MatchcodeEditorCollapse= |
| {| 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 mw-collapsed" 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:Survivorship Pass-Through|Survivorship/Pass-Through]]
| |
| |-
| |
| |[[SSIS:MatchUp:Lookup Pass-Through|Lookup Pass-Through Columns]]
| |
| |-
| |
| |[[SSIS:MatchUp:Output Filter|Output Filter]]
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible" 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]]
| |
| |}
| |
| |}
| |
|
| |
|
|
| |
|
← SSIS:Data Quality Components
Below the matchcode list is a list of components used by the currently-selected matchcode.
The list also shows the basic settings for each combination. The right side of the list contains a grid that shows the combinations in which component is used. For more information on how combinations of components are used, see Component Combinations.
Add a New Component to the Matchcode
- Select the [Select Data Type] dropdown list.
- The Matchcode Editor displays a list of 35 available Data Types and an additional General Data Type to choose from.
- Select the settings for the new component.
- You can click on the different sections of the added component for more settings.
- Click OK.
- The new component is added as the last component in the matchcode.
Remove a component from a matchcode
- Select the Component Data Type dropdown list.
- Navigate to the top of the list and select [Remove Component].
- Place the focus on another control and the component will be removed from the component list.
Change the order of components in a matchcode
- Click on the name of the component.
- Drag the component to the new position.