One of the PowerCenter 9.6.1 session with Dynamic lookup fails with the following error:
ERROR : (1303 | LKPDP_2:TRANSF_1_1) : (IS | is_na1dev96) : na1etl96_node_na1etldev2 : CMN_1650 : A duplicate row was attemptedto be inserted into a dynamic lookup cache [LKP_SET_FLAG]. The dynamic lookup cache only supports unique condition keys.
From PowerCenter 9.6, Lookup transformation can be active or passive.
This issue occurs when the table on which the lookup is built has duplicate rows. As a dynamic cached lookup cannot be created with duplicate rows, the session fails with this error.
To resolve the issue, select Use first value or Use Last value for Lookup Policy on Multiple Match at the Lookup transformation PowerCenter 9.6.1.
What can we do to improve this information (2000 or fewer characters)