when we go for unconnected lookup transformation? and why?
Answers were Sorted based on User's Feedback
Answer / harry
When we want to get single return value, and also we can
call this anywhere in the mapping
Is This Answer Correct ? | 14 Yes | 2 No |
Answer / pooja ahmed
1. When we want to get single return value
2. also we can call this anywhere in the mapping
3. when no.of recs are less go for unconn lkp, which improv
t\da performacesa
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / arvind
When we want to get single return value, and also we can
call this anywhere in the mapping
In addition to this it gives u the flexibility to run
lookup for selected source rows which u dont find in
connected lookup
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / guduri hari
When we want to get single return value,we can call this
anywhere in the mapping...
> when no.of recs are less go for unconn lkp, which improve
the performancee
unconnect give performance edg
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
how to run the batch using pmcmd command
What is depict expression change?
What is the reusable transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Can you access a repository created in previous version of Informatica?
Types of error logs in Informatica?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
How can informatica be used for an organization?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
Explain the scenario which compels informatica server to reject files?
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
what is bridge tables in informatica