DSXchange

Getting following warning and couldn't fix it..
any help appreciated..

RmDp_3: When checking operator: User inserted sort "Srt_3" does not fulfill the sort requirements of the downstream operator "RmDp_3"

Used same partition method and keys in rem dup stage. In sort stage with same keys it was hash partitioned and sorted.. and set the partion in sort stage.

But still cannot avoid the warning.

The keys you are using in the Remove Duplicates stage do not match with the keys you sorted on before it.

remove dup keys are same as sort stage keys...

If that was true, you wouldn't be seeing the warning.

even though the sort and remove dup keys are different now,After including the ENV variable APT_NO_SORT_INSERTION to yes warnings were gone..

So just trying to understand what does this do or mean?

You told DataStage NOT to insert any sorts into the job. And pretty much guaranteed that it isn't going to work correctly if a sort IS required.

That's a very dangerous option to use.

Oh ok thanks but not able understand what I am missing and how solve the issue..