What are the Differences between connected and unconnected
lookup?
Answer Posted / swetha
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.
yoU 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 maping
lookup condition and the lookup/return port.
Support user defined default values Does
not support user defiend default values
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is sq transformation?
How to go to the older version for a mapping?
Explain dynamic target flat file name generation in informatica
While migrating the data from one environment to another environment how would you manage the connections?
Tell me about Propagate functions in informatica
How to do unit testing in informatica?
What is lookup change?
what is the difference between informatica6.1 and infomatica7.1
How do you take back up of repository?
What is the fact table?
What is the use of code page?
How many ways are there to create ports?
Why filter transformation is an active one?
What are the different types of repositories created using informatica?
What are the differences between a connected lookup and unconnected lookup?