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 are the performance considerations when working with aggregator transformation?
Write the program through which the records can be updated?
Explain the different lookup methods used in informatica?
where to store informatica rejected data?
What does “tail –f” command do and what is its use as an Informatica admin.
What is lookup change?
In how many ways we can create ports?
What is the function of union transformation?
When do you use sql override in a lookup transformation?
What is the Rank index port in Rank transformation?
While migrating the data from one environment to another environment how would you manage the connections?
What are the tasks that can be performed using sq?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is DR strategy for Informatica project?