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
Implementation methodology
Could you explain what is enterprise data warehouse?
What is update strategy transform?
What is the difference between informatics 7x and 8x and what is latest version?
what is the hint? how to use it to reduce the query processing in program?
What you know about transaction control transformation?
What is an expression transformation?
What are some examples of informatica etl programs?
How to improve the performance of a session using sorter transformation?
Explain load alternative records / rows into multiple targets - informatica
How you know when to use a static cache and dynamic cache in lookup transformation?
Define Pmrep command?
What is the difference between informatica 7.0 and 8.0?
Explain about cumulative Sum or moving sum?
What are the tuning techniques you applied during your last project