Page 1 of 1
With out sort stage
Posted: Tue Jan 27, 2009 4:50 pm
by mandyli
Hi,
With out sorting stage shall i use any other stages for sorting?
Thanks
Man
Posted: Tue Jan 27, 2009 5:33 pm
by ray.wurlod
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.
Posted: Tue Jan 27, 2009 5:52 pm
by mk_ds09
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