SSIS:MatchUp:Lookup Pass-Through

From Melissa Data Wiki
Jump to navigation Jump to search

← SSIS:Data Quality Components

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



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.


SSIS MU LookupPassThrough.png


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.