How to avoid Lookup Warning

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
suresh.angadi
Participant
Posts: 17
Joined: Tue Jun 23, 2009 6:44 pm

How to avoid Lookup Warning

Post by suresh.angadi »

Hi All,

Can anyone guide to avoid this warning, apart from using 'message handler'

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

Regards
Suresh
Suresh Angadi
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: How to avoid Lookup Warning

Post by SURA »

Sorry

It might be because of Dup record i guess.

Use a remove dup stage may take out this warning

DS User
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You have duplicates in your reference data set. Either enable return of more than one row from the reference input link in the Lookup stage, or ensure that you have no duplicates in the reference data set.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply