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
Preserving Sort Order After Join Stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 36
- Joined: Wed Dec 27, 2006 3:50 am
- Location: Phoenix
The join stage will output data sorted on the join keys. If the sort order is different before the join, DataStage will perform implicit sorts on the input streams.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 36
- Joined: Wed Dec 27, 2006 3:50 am
- Location: Phoenix
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: