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