DSXchange

How to sort data in Server edition Jobs

I can see sort stage in Parallal edition for parallal and server jobs

but in server edition , how we are sorting?

Sort stage

Sort stage, as Ken suggests, is available in server jobs. But it's slow.

If you have a DOS command line sorter available, it may be preferable to use that, perhaps as the Filter command in a Sequential File stage.

Other possibilities include a UV stage (or any other database stage) - load the data into a table then re-extract the data with an ORDER BY clause - this will be quite fast if you index the sorting column(s). You could also write your own sort routine if you're good at that sort of thing.