User inserted sort does not fulfill the sort requirements warning in IBM InfoSphere DataStage 8.x
The job worked in DataStage (DS) 7.5.2, but when run in DS 8.x, gets a warning from the Remove Duplicates (rem dup) stage.
Job log contains:
Message: <Remove_Duplicates_stage>: When checking operator: User inserted sort "<name>" does not fulfill the sort requirements of the downstream operator "<name>"
The user inserted partitioners and sorts key order do not match the join key order.
Resolving the problem
Set the following parameters to True:
More support for:
Software version: 8.0.1, 8.1, 8.5, 8.7
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1428660
Modified date: 02 April 2012