DSXchange

When using a sorted Dataset as input to a join statement, if we don't put a Sort Stage set to "do not sort" and "same", the Join stage insert an internal Tsort even if we set the input partitioning of the Join stage to "same"

In conclusion, in order for Datastage NOT to put an internal Tsort, you must put a Sort Stage prior to the Join stage set to "do not sort" and "same".

Is this correct or is there anther way. It just seems like clutter on the palette.

Could someone please confirm.

Thanks

What you call "clutter" I call a useful piece of information.

You can also use an APT variable to turn off automatic TSORT insertion for that entire job but I personally would recommend sticking with the Sort stage.

Don't get me wrong, I just thought that if we could set this in the join stage, less stages would exist on the palette. I agree that it's useful.

Thanks for the answer.

I don't believe there is such an option in the Join stage... but let's see what others have to say. Pretty sure those are your two options.

There is no such option in the Join stage.

Thanks for the info. I will mark this resolved.