Interested to Buy Any Domain ? << Click Here >> for more details...
when we go for unconnected lookup transformation? and why?
- 5 Answers
- 14311 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
how to import multiple flat files in to single target where there is no common column in the flat files
What is repository manager?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the data movement modes in informatcia?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
What is a passive transformation?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Differnce between filter and router?
How you can differentiate between connected lookup and unconnected lookup?
Did u used latest transformations of 8.6.0? for what?
Teradata 
