when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
Answer Posted / jeevan kumar medapati
if u want to perform look up on less values then we go for
connected lkp
if u want to perform look up from more than one table then
we go for un connected lkp
in ur source u have more date columns then we should go for
unconnected lkp.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What do you mean by worklet?
Define mapping and session?
What can we do to improve the performance of informatica aggregator transformation?
permutations of mapplet
Explain why we use partitioning the session in informatica?
How does the aggregator transformation handle null values?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How do you load alternate records into different tables through mapping flow?
Why do we need informatica?
What is difference between a gateway node and worker node?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are roles and groups and benefits of using them?
What are mapplets? How is it different from a Reusable Transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What does cheating measurement mean?