DSXchange

Hi all,

In sort Stage->Properties->Sorting keys

Wht is the meaning of Don't sort(Previously Grouped)?

Is it to do with Data Partitioning or Group by at SQL level?

Can any body explain how to use it?

Thanks
Prashant

Hi,

If the input records already sorted by this column set SORT MODE=Don't sort, if records are not sorted already on this column use SORT MODE=Sort


Regards
Beeram

Hi Beeram,

This is an answere to Don't Sort(Previously Sorted) option.
I am looking for an ans to Don't Sort(Previously Grouped) option.

Thanks
Prashant

Even so, it's the same answer as the one Beeram gave.

If you think about it, the only efficient way that grouping can be achieved is by sorting, then detecting change.

The difference between "don't sort (previously sorted)" and "don't sort (previously grouped)" is, therefore, primarily about documenting the reason for not re-sorting the data stream, or at least that column in the data stream.

Thanks Ray