Implicit/Explicit Sort

Gopinath · Post by **Gopinath** » Thu Feb 19, 2009 12:52 am

Hi,

I am sorting the input record for Join/CDC stages. But if i give implicit sort iam getting an warning "does not not fulfill sort requirement", but if i use Explicit sort, iam not getting any warnings.

Which way is advisable, implicit or Explicit. What is the advantage/disadvantage among the two.
Can anybody guide me on this.
Thanks.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 19, 2009 1:27 am

Explicit, because you don't get any warnings. Also you have greater control over resources allocated to the sorting process.

Gopinath · Post by **Gopinath** » Sat Feb 21, 2009 10:18 am

Thanks Ray.
But lets say, if i have 2-3 join stages and much more stages which requires sorted records then i have to use explicit sort stages and also if i have multiple jobs which have schedhuled at the same time, which has more explicit sort stages then how this resource disk will handle that. Will it support. This is also another concern for us in using explicit sort.
Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Sat Feb 21, 2009 2:10 pm

DataStage will support as many as you have hardware resources to support.

Explicit sort may be even better here, because you have the "don't sort, already sorted" capability that lets you perform sub-sorts.

Gopinath · Post by **Gopinath** » Sun Feb 22, 2009 12:03 pm

Thanks Ray.