DSXchange

We have a job that we migrated from 8.5 to 11.5 which was giving incorrect results. We narrowed this down to a transformer messing up the sort order after reading from a sort stage.
We have tried changing the partition to "Same" but didnt work.
The only way the transformer appears to maintain the sort order is if it is run in Sequential mode.
I have also tried sorting again in the transformer using the same keys as the sort stage but that failed as well.

Any suggestions?

If you set the partitioning to "same" and are not modifying the key column in the transformer, then the order won't be changed.
Turn on $APT_DUMP_SCORE and see what operators are actually being called; and perhaps you might try disabling combination of operators ($APT_DISABLE_COMBINATION) to see if that might be having an affect on your problem.

Do contact IBM support for this issue.

Each time I have seen "strange things" going on related to the Transformer stage, it has been caused by using the wrong compiler version. A major, minor, or fix pack difference in the compiler version can definitely cause unusual, incorrect behaviors. Double check system requirements' exact version listed against the version you have installed.