Hi,
With out sorting stage shall i use any other stages for sorting?
Thanks
Man
With out sort stage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you wish. Most stage types support sorting on their input links, but none offers the flexibility available with an explicit Sort stage.
The main thing is not to sort where it's unnecessary.
The main thing is not to sort where it's unnecessary.
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.
The major performance imporvement can be acheived by avoiding the unnecessary sorting.
As ray said, u can check the input properties of the most of the stages which will provide you the sorting option..
However if you still wants to check how sorting should be done
check the suage of the APT_NO_SORT_INSERTION.
Whenever there is sorting DS automatially puts the sort operator, using above varibale you can prevent this automatic insertion..
hope this helps
----------------------
MK
As ray said, u can check the input properties of the most of the stages which will provide you the sorting option..
However if you still wants to check how sorting should be done
check the suage of the APT_NO_SORT_INSERTION.
Whenever there is sorting DS automatially puts the sort operator, using above varibale you can prevent this automatic insertion..
hope this helps
----------------------
MK