dear experts,
i have a question.( parallel DS8/AIX5.3)
what is the difference between
sorting using a sort stage and
using a transfomer with hash partioning and checking the sort checkbox??
appreciate your help,
regards.
sorting in sort stage Vs Transformer
Moderators: chulett, rschirm, roy
The sort stage gives you more options and control.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
The implicit sort lets you choose key and order. Add a sort stage to your designer canvas and check which options you can specify there to see the difference.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
All sort methods (explicit (Sort stage), implicit (input link) and inserted) use the same tsort operator. It's just that an explicit Sort stage gives you access to more of the operator's options.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
The sort stage also looks better - you can see that a sort is happening rather than hiding it away on the partitioning tab. If you are going to insert custom partitioning and sort options on the advanced tab I would recommend adding a job annotation to explain what you have done.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: