top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to lookup is acting as both active and passive ? how is it possible?

+1 vote
1,365 views
How to lookup is acting as both active and passive ? how is it possible?
posted Aug 11, 2015 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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.

answer Aug 11, 2015 by Manikandan J
...