Duplicate Entry +Lookup

Madhusv · Post by **Madhusv** » Tue Sep 13, 2005 5:05 am

Hi,

I am using the lookup stage in which lookup is happenning for 32 fields,

I am getting the below error, I couldn't make out from which link duplicate entry is coming, i have selected mulitple rows returned from link option for one link, Still i am getting the same error.

Another thing is 31 lookup is happenning for the same table, I am using transformer constraints to split the links.

LKP_Msds_IsyCode,0: Ignoring duplicate entry at table record 1; no further warnings will be issued for this table [keylookup/keylookup.C:852]

Regards,
Madhu

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Sep 13, 2005 7:03 am

That is because your lookup source has dupl keys.

You need to decide whether it is valid or not and set accordingly.

Madhusv · Post by **Madhusv** » Mon Sep 19, 2005 5:01 am

Hi,

Source is coming from join stage also in db2 stage i am taking distinct of the key coulumn, I think the problem is with32 lookups, if any one has faced similar situation, Please let me know.

Regards,
Madhu