Connected lookup
Unconnected lookup
Receives input values diectly from the pipe line.
Receives input values from the result of a 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 used in the maping
Cache includes all lookup out put ports in the lookup condition and the lookup/return port.
Support user defined default values
Does not support user defiend default values
No comments:
Post a Comment