User inserted sort does not fulfill the sort requirements warning in IBM InfoSphere DataStage 8.x

Technote (troubleshooting)


Problem(Abstract)

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:

Warning
Message: <Remove_Duplicates_stage>: When checking operator: User inserted sort "<name>" does not fulfill the sort requirements of the downstream operator "<name>"

Cause

The user inserted partitioners and sorts key order do not match the join key order.

Resolving the problem

Set the following parameters to True:

APT_NO_PART_INSERTION
APT_NO_SORT_INSERTION


Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere DataStage

Software version:

8.0.1, 8.1, 8.5, 8.7

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1428660

Modified date:

2012-04-02

Translate my page

Machine Translation

Content navigation