Remove duplicate Error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dspxlearn
Premium Member
Premium Member
Posts: 291
Joined: Sat Sep 10, 2005 1:26 am

Remove duplicate Error

Post by dspxlearn »

Hi all,


When i am trying to remove duplicates from the iput link of the remove duplicate stage, it is giving an warning as,

Remove_Duplicates_367: When checking operator: User inserted sort "Remove_Duplicates_367.DSLink358_Sort" does not fulfill the sort requirements of the downstream operator "Remove_Duplicates_367"

I was using Hash partitioning and enabled Sorting option as 'Perform Sort'


What might be the possible problem... :D
Thanks and Regards!!
dspxlearn
dspxlearn
Premium Member
Premium Member
Posts: 291
Joined: Sat Sep 10, 2005 1:26 am

Post by dspxlearn »

Sorry guys...This message should be given parallel jobs..
Thanks and Regards!!
dspxlearn
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

The sort keys on the sort stage need to be the same as the remove duplicate keys. Better yet you can remove duplicates in the sort stage using one of the properties. From memory the only thing the remove duplicates gives you that isn't in the sort stage is a "Last" option.
Post Reply