|
|
| 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
This tab is HIDDEN When there is only a single upstream source connected to the MatchUp Component.
This shows a list of the fields in your input Lookup stream. When there is only a single input source connected, this tab will not be visible.
- Pass Through
- Check this box if you would like the contents of the checked field name to be passed to the Lookup output stream without modification, in addition to the Output Columns specified in Options.
- Column Name
- The column names from the original input table.
- Current Usage
- Where the field is currently being used as input.
- Data Type
- The data type of each column.
- Length
- Maximum number of bytes returned.
- Precision
- Maximum number of digits.
- Scale
- Maximum number of digits to the right of the decimal point.