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
Explain lookup transformation is active in informatica
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What all join we can perform in LOOKUP transformation?
Did u used latest transformations of 8.6.0? for what?
Differentiate between source qualifier and filter transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
COM components can be used in Informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is a code page?
What is an expression transformation in informatica?
Explain how to import oracle sequence into informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
how we can load rejected record's at run time?(not through bad files)
How can we update a record in the target table without using update strategy?
What are the informatica performance improvement tips