|
|
|
|
| Re: difference between connected / unconnected lookup [message #158968 is a reply to message #137993] |
Wed, 15 February 2006 04:49  |
krsoujanya
Messages: 8
Registered: July 2005
|
Junior Member |
|
|
the differences between connected and unconned lookups are as follows:
Connected lookup:- 1. Receives input values directly from the pipe line.
2. You can use a dynamic or static cache.
3. Cache includes all lookup columns used in the mapping.
4. Support user defined default values.
Unconnected lookup:-
1. Receives input values from the result of an lkp expression in another transformation.
2. You can use a static cache.
3. Cache includes all lookup out put ports in the lookup condition and the lookup/return port.
4. Does not support user defined default values.
the main advantages of the unconnected lookup is if suppose u can use the same lkp transformations 2 or more times in a same mapping its waste of time. in that situations, we can create unconnected lkp transformation and call that expression wherever u want.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
