warning at LOOKUP

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
deesh
Participant
Posts: 193
Joined: Mon Oct 08, 2007 2:57 am

warning at LOOKUP

Post by deesh »

Hi Friends

I am getting below warning Can any one help to solve warning


LOOK_MITBAL,0: Ignoring duplicate entry at table record 834; no further warnings will be issued for this table
Top
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

By searching the forum you can help yourself.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Top
ithirak_17
Participant
Posts: 17
Joined: Mon Sep 10, 2007 3:24 am

Re: warning at LOOKUP

Post by ithirak_17 »

Please check the lookup table.. the key used is not unique... there is more duplicate records in it.. Choose primary key of the table.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Or, if you want to be able to return the duplicates from this link, enable that functionality in the Lookup stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”