Interested to Buy Any Domain ? << Click Here >> for more details...
when we go for unconnected lookup transformation? and why?
- 5 Answers
- 14389 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 |
What are the differences between joiner transformation and source qualifier transformation?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
How to load last 10 records of flat file in to the target?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Please let me know how to make Data masking in informatica..
What is blocking transformation?
what is degenerated dimension?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
what is target update override and when we use it?
Howmany ways yoU can update a relational source defintion and what are they?
How to load time dimension?
What is the query to find nth highest salary? What is the use of cursors?
Teradata 
