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
What do you mean by channel change?
Name the different lookup cache(s)?
What is standalone command task?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is the different lookup cache(s)?
Define mapping and session?
what is Active lock explain
What are the modules in Power Center
In how many ways we can create ports?
Explain scd type 3 through mapping.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
waht type of interface is used for testing the data in informatica
How to load data in informatica ?
Differentiate between a database and data warehouse?
What are the types of caches in lookup?