Database Reference
In-Depth Information
tional lookup table, Integration Service extracts the data with only the lookup
port. This helps to reduce the data extracted from the lookup source.
•
Return Port (R)
: This is only used in the case of an unconnected Lookup trans-
formation. It indicates which data you wish to return in the Lookup transforma-
tion. You can define only one port as the return port, and it's not used in the case
of connected Lookup transformations.