Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Differences between connected and unconnected
lookup?
- 6 Answers
- 21388 Views
- TCS, I also Faced
- E-Mail Answers
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
How to update source definition?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How can we create index after completion of load process?
What does reusable transformation mean?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the issues you have faced in your project? How did you overcome those issues?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain lookup transformation in informatica
Explain direct and indirect flat file loading (source file type) - informatica
what is the complex transformation you used in informatica
How do you load only null records into target?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain about cumulative Sum or moving sum?
What is a difference between complete, stop and abort?
What is native users?
