Lookup Stage - 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
Maharaj
Participant
Posts: 13
Joined: Tue Feb 03, 2004 3:50 pm

Lookup Stage - Warning

Post by Maharaj »

Hi

In my parallel job iam using a lookup stage to lookup against my DataSet. Please find below the warning iam getting on the successfull completion of the job. Is it because of the Multiple rows in the DataSet for the same data.?

LookupStage Warning:

Ignoring duplicate entry at table record 8920; no further warnings will be issued for this table Ignoring duplicate entry at table record 8920; no further warnings will be issued for this table

Please let me know how to fix this warning .

Thanks in advance
:)
nelab28
Premium Member
Premium Member
Posts: 28
Joined: Fri Sep 24, 2004 1:25 am

Post by nelab28 »

Hi,
You might want to try this:
In the constraints of the lookup stage, choose the "multiple rows returned from link" on the reference link that might be returning multiple values.
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post by T42 »

There are duplicate keys on the reference link. Do you want to match all records (and in the results, create new records for output)? If so, disable "Ignore Duplicates".
Post Reply