What are the differences between Connected and
Unconnected Lookup?
The differences are illustrated in
the below table
|
Connected Lookup
|
Unconnected Lookup
|
|
Connected lookup participates in
dataflow and receives input directly from the pipeline
|
Unconnected lookup receives input
values from the result of a LKP: expression in another transformation
|
|
Connected lookup can use both
dynamic and static cache
|
Unconnected Lookup cache can NOT be
dynamic
|
|
Connected lookup can return more
than one column value ( output port )
|
Unconnected Lookup can return only
one column value i.e. output port
|
|
Connected lookup caches all lookup
columns
|
Unconnected lookup caches only the
lookup output ports in the lookup conditions and the return port
|
|
Supports user-defined default values
(i.e. value to return when lookup conditions are not satisfied)
|
Does not support user defined
default values
|
