Link sort/Stage sort

What is the use of sort stage when you have explicit sort stage?

Questions by srikanth.ds   answers by srikanth.ds

Showing Answers 1 - 9 of 9 Answers

vkamatag

  • Dec 8th, 2009
 

It is OK in the development environment if we do the In-Link sorting, as the data in DEV will be small when compared to QA and PROD, but in real time the job will get aborted with the error “Scratch disk Space Full”.The Sort Stage should be used instead of In-Link Sort. In-Link sorts should be used only for low volume data.

Vinay.
 

  Was this answer useful?  Yes

praveen.sarva

  • Dec 1st, 2010
 

Simple... For huge amount of data we prefer link sorting... Under partitions for small and compatable data we use stage sort(nothing but sort with in data set).

  Was this answer useful?  Yes

nikhilanshuman

  • Dec 9th, 2010
 

Link Sort and stage sort,both do the same thing.Only the Sort Stage provides you with more options like the amount of memory to be used,remove duplicates,sort in Ascending or descending order,Create change key columns and etc.These options will not be available to you while using Link Sort.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions