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 the advantage of informatica?
How would you join a node to the already existing domain?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is a filter transformation?
What is the use of target designer?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is the size of your data warehousing?
What are the conditions needed to improve the performance of informatica aggregator 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)
Please let me know how to make encryption and decryption with example?
What if the source is a flat-file?
how to load dimension table and fact table. plz tell me the steps.
How can repository reports be accessed without sql or other transformations?
Can we override a native sql query within informatica?