Interested to Buy Any Domain ? << Click Here >> for more details...
when we go for unconnected lookup transformation? and why?
- 5 Answers
- 14526 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 |
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
If we are using an aggregator but forget to mention the group by port .what will be the output??
How to create the source and target database connections in server manager?
Is it possible to have "5 source & 5 Target" in single mapping?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
What is the use of source qualifier?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Diffrence between 7.1,8.1 and 8.6
How can you validate all mappings in the repository simultaneously?
How many types of sessions are there in informatica.please explain them?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
Teradata 
