|
|
| (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
This top portion of the interface contains a list of all the matchcodes found in the current matchcode file.
To the right of the list are four buttons: Create Matchcode, Remove Matchcode, Copy Matchcode, and Rename Matchcode.
Add a New Matchcode
- Click the Create Matchcode button.
- Type a name for the new matchcode in the pop-up and click OK. The Matchcode Editor will present a blank matchcode screen with no components.
- Add components.
Remove an Existing Matchcode
- Select the matchcode to be deleted.
- Click the Remove Matchcode button.
- Click Yes to confirm the deletion.
Make a Copy of an Existing Matchcode
- Select the matchcode to be copied.
- Click the Copy Matchcode button.
- Type a name for the new matchcode in the pop-up box and click OK.
Rename an Existing Matchcode
- Select the matchcode to be renamed.
- Click the Rename Matchcode button.
- Type a new name for the matchcode in the pop-up box and click OK.