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 |
No comments:
Post a Comment