sorting in sort stage Vs Transformer

reddy12 · Post by **reddy12** » Fri Aug 08, 2008 7:43 am

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.

ArndW · Post by **ArndW** » Fri Aug 08, 2008 7:54 am

The sort stage gives you more options and control.

reddy12 · Post by **reddy12** » Fri Aug 08, 2008 8:02 am

thanks for the Reply.

can you be more specific ???

Regards.

ArndW · Post by **ArndW** » Fri Aug 08, 2008 8:46 am

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.

reddy12 · Post by **reddy12** » Fri Aug 08, 2008 8:59 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 08, 2008 4:22 pm

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.

vmcburney · Post by **vmcburney** » Mon Aug 11, 2008 8:14 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 11, 2008 8:25 pm

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