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