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
Sort Stage
Moderators: chulett, rschirm, roy
sort mode
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
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
-
Prashantoncyber
- Participant
- Posts: 108
- Joined: Wed Jul 28, 2004 7:15 am
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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.