when we go for unconnected lookup transformation? and why?
Answer Posted / suneel reddy
Answers 1:
Depending upon the scenario we use the conn and unconn tr..
for e.g
In u r mapping u require same lkp multiple times, creating
lkp multiple times put it in flow is not a good idea, which
occupies more cache ...
Instead of that create one unconnectes lkp use multiple
times where ever u want , which very fast..
Answers 2:
u can use conn lookup but if u need 1 row so go for unconn
lookup coz u can
use it multiple time in same mapping from multiple
expression trn.
i hope it will help to u
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define enterprise data warehousing?
What is workflow monitor?
Explain the scenario which compels informatica server to reject files?
What is event and what are the tasks related to it?
How union transformation is used?
How to extract sap data using informatica?
What is union transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How can we store previous session logs?
How can we handle two sessions in informatica?
can anyone explain me about retail domain project in informatica?
How to do unit testing in informatica?
difference between informatica 8.1.1 and 8.6
Enlist some properties of sessions.
How can we use mapping variables in informatica?