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.
Implicit/Explicit Sort
Moderators: chulett, rschirm, roy
Implicit/Explicit Sort
Gopinath
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Gopinath
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Explicit sort may be even better here, because you have the "don't sort, already sorted" capability that lets you perform sub-sorts.
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.