Monday, September 14, 2009

Differences between connected and unconnected lookup?

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: