Which one is better performance wise connected/un-connected
lkp?why?
Answer Posted / yamini
Performance wise unconnected look up transformation is better as it returns only one port and doesn't build any dynamic cache. Only static cache is build. It can be used any where in the mapping using LKP expression in another transformation.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can u generate reports in Informatica?
What is primary and backup node?
What are the components of Informatica? And what is the purpose of each?
Explain joiner transformation in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Sequence generator, when you move from develoment to production how will you reset
Write the unconnected lookup syntax?
What is the difference between informatica 7.0 and 8.0?
Make a note of the quantity vaults made in informatica?
What is flashback table ? Advance thanks
What all join we can perform in LOOKUP transformation?
What is joiner transformation?
Define the various join types of joiner transformation?
What is source qualifier transformation in informatica?
What are the new features of informatica 9.x developer?