Warning in Remove Duplicates Stage

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
srini_ramesh
Participant
Posts: 13
Joined: Fri Oct 08, 2004 6:19 am

Warning in Remove Duplicates Stage

Post by srini_ramesh »

Hi,
while using Remove duplicates stage I get this warning.
"Remove_Duplicates_22: When checking operator: User inserted sort "Remove_Duplicates_22.DSLink27_Sort" does not fulfill the sort requirements of the downstream operator "Remove_Duplicates_22""

Please explain how this can be resolved.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

In order for the duplicates to be removed, you need to sort on the column(s) you are using to remove duplicate rows. Are you doing this?
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post by T42 »

You are attempting to sort on all (or less) of the keys you're trying to remove duplicate on. You need to sort on all keys, PLUS one data field.
Post Reply