DSXchange

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.

The sort stage gives you more options and control.

thanks for the Reply.

can you be more specific ???



Regards.

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.

does both the operators use the scratch space for sorting the data in both cases or only the sort uses the scratch space and transformer uses the resource disk???

regards.

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.

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.

You do get a Sort link marker (unless, of course, you disable display of link markers).