how lookup is acting as both active and passive ?
how is it possitble?
Answer Posted / meenal
In Informatica 9.1 Lookup is active because of property - "Lookup policy on multiple match", this can be chosen as first, last, any value or all values. So now we can configure the Lookup transformation to return all rows that match a lookup condition. Hence, a Lookup transformation is an active transformation when it can return more than one row for any given input row.
However this property is available only for connected lookup, unconnected lookups are still passive.
| Is This Answer Correct ? | 43 Yes | 0 No |
Post New Answer View All Answers
Please let me know how to make encryption and decryption with example?
draw informatica architecture 8.6 ?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Define joiner transformation?
can anyone explain me about retail domain project in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
How identifying bottlenecks in various components of informatica and resolving them?
What is rank transform?
How to use pmcmd utility command?
How to join three sources using joiner? Explain though mapping flow.
What is informatica worklet?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
what is index?how it can work in informatica
Enlist the differences between database and data warehouse.
How to open an older version of an object in the workspace?