[RESOLVED] Lookup Policy on Multiple Match

Featured

vinoth.kumar on Wednesday, February 15 2012, 10:03 PM

Posted in : Informatica
Subscribe Subscribe to this discussion via emails

[RESOLVED] Lookup Policy on Multiple Match - Informatica 9.1

Am using Infa 9.1.

But when I create the lookup transformation am not able to see the new feature added in Informatica 9.1 lookup transformation which Use All Values. Return all matching rows.

Please let me know how to set this option in Informatica 9.1 lookup transformation

Thanks in advance.

Resolved

The discussion has been resolved.

Locked

The discussion has been locked.

Accepted Answer

0
Replied by saurav.mitra on Thursday, February 16 2012, 02:04 AM

Go to Transformation and click on Create.Next select the transformation type as Lookup.
Next enter a name for Lookup Transformation and click the Create button.
On the selection box of the Lookup Table you will find a checkbox at the bottom Return All Values on Multiple Match.Check this box to make the Lookup Transformation active.
Now go to the Properties tab and check that the value of the attribute Lookup Policy on multiple match is set to Use All Values.