Interested to Buy Any Domain ? << Click Here >> for more details...
lookup is passive y can't it be active?
let us say i have some records in my source like
101,rohit,1000
101,rohit,1000
102,kumar,2000
like wise
now as it is having multiple matches i return only
first,last value it can't return bouth the values
that means lookup is acting as select distinct right by
default what means it is active?
- 5 Answers
- 8250 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / varun4db
In this case for first row with 101 id it will give random(
either first or last or any or error). And again for second
row 101 it will return any random( either first or last or
any or error).
So the count of out put row is equal to the input row. so it
is passive only.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create the source and target database connections in server manager?
Is it possible to define a single node as a Gateway node as well as worker node?
which one is better performance wise joiner or look up
What is status code in informatica?
What is the need of etl tools?
wat are deployement groups in informatica, how it will be used for developers
How can you validate all mappings in the repository simultaneously?
What is sq transformation?
How we can use union transformation?
Global and Local shortcuts. Advantages.
How big was your fact table
what is the difference between informatica6.1 and infomatica7.1
What is the benefit of session partitioning?
write a query to retrieve the latest records from the table sorted by version(scd)
Write the unconnected lookup syntax?
