Connected lookup Unconnected lookup
Receives input values diectly from Receives input values from the result of a
the pipe line. lkp expression in a another transformation
U can use a dynamic or static cache U can use a static cache
Cache includes all lookup columns Cache includes all lookup out put ports in the
used in the mapping lookup condition and the lookup/return port
Support user defined default values Does not support user defiend default values
No comments:
Post a Comment