we have sort and sort within groups components. we can achieve the sort within group functionality by palcing two keys in sort group. then why i go for sort within gropus?
Total Answers and Comments: 7
Last Update: November 28, 2008 Asked by: prabhupurna
RE: we have sort and sort within groups components. we...
Hi
sort with in groups refines the data which is already sorted according to a key.ie it regroups the data which is already grouped with a key.but using sort we cannot achieve this.
RE: we have sort and sort within groups components. we...
The prerequisit for using sort within group is the data is already sorted by the major key.
Sort within group can output the data to the out flow once it has finished reading the major key group. It allows data streamline flow. Conversely sort will not output the data until all input data has been read so it is like a implicity phase.
RE: we have sort and sort within groups components. we can achieve the sort within group functionality by palcing two keys in sort group. then why i go for sort within gropus?
SORTWITHINGROUP refines the sort order by the secondary key in group and maintains a pipeline parallelism which is not often acheived by using SORT.
