Warning in Look up Stage

Ankur_KapoorUK · Post by **Ankur_KapoorUK** » Tue Mar 16, 2010 11:50 am

Hi ,

I am getting a warning in Look up Stage :-

Lkp_UNQ_ID_IN_SRC_STM_ID,0: Ignoring duplicate entry at table record 1; no further warnings will be issued for this table.

Kindly provide help !!!!

Thanks,
Ankur

chulett · Post by **chulett** » Tue Mar 16, 2010 12:25 pm

Which part is unclear? Have you done an exact search for "Ignoring duplicate entry"?

mallikharjuna · Post by **mallikharjuna** » Tue Mar 16, 2010 12:43 pm

use remove duplicate stage on key before doing the lookup that means remove duplicates in reference data.

Ankur_KapoorUK · Post by **Ankur_KapoorUK** » Wed Mar 17, 2010 8:12 am

Thanks .... The issue is resolved now.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 17, 2010 7:33 pm

Can you please let everyone know HOW it was resolved?

Kryt0n · Post by **Kryt0n** » Wed Mar 17, 2010 8:40 pm

And is it a business agreed solution...

While remove duplicates will indeed resolve it, is that actually the correct solution?