Preserving Sort Order after join stage

[anand_dafaria]

Just wanted to check, whether sort order is preserved in the output of join stage, once we join (inner,Left Outer, Right Outer or Full Outer) the two input links which are already Hash Partitioned and Sorted on the joining keys.

I never faced any issue with the sort order once join operation is perfomed, but this is actually been questioned. Let me know the correct functionality of the join stage in prserving the sort order.

Thanks
Anand

[ray.wurlod]

Is this in a QualityStage job? (You have posted in the QualityStage forum.)

[anand_dafaria]

Ray,
I moved this Datastage forum