Page 1 of 1

Warning in Look up Stage

Posted: Tue Mar 16, 2010 11:50 am
by Ankur_KapoorUK
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

Posted: Tue Mar 16, 2010 12:25 pm
by chulett
Which part is unclear? Have you done an exact search for "Ignoring duplicate entry"?

Posted: Tue Mar 16, 2010 12:43 pm
by mallikharjuna
use remove duplicate stage on key before doing the lookup that means remove duplicates in reference data.

Posted: Wed Mar 17, 2010 8:12 am
by Ankur_KapoorUK
Thanks .... The issue is resolved now.

Posted: Wed Mar 17, 2010 7:33 pm
by ray.wurlod
Can you please let everyone know HOW it was resolved?

Posted: Wed Mar 17, 2010 8:40 pm
by Kryt0n
And is it a business agreed solution...

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