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
-
Ankur_KapoorUK
- Participant
- Posts: 64
- Joined: Fri Feb 05, 2010 5:29 am
- Location: India, UK
Post
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
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Which part is unclear? Have you done an exact search for "Ignoring duplicate entry"?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
mallikharjuna
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
Post
by mallikharjuna »
use remove duplicate stage on key before doing the lookup that means remove duplicates in reference data.
MALLI
-
Ankur_KapoorUK
- Participant
- Posts: 64
- Joined: Fri Feb 05, 2010 5:29 am
- Location: India, UK
Post
by Ankur_KapoorUK »
Thanks .... The issue is resolved now.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Can you please let everyone know HOW it was resolved?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
Kryt0n
- Participant
- Posts: 584
- Joined: Wed Jun 22, 2005 7:28 pm
Post
by Kryt0n »
And is it a business agreed solution...
While remove duplicates will indeed resolve it, is that actually the correct solution?