GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Abinitio

 Print  |  
Question:  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?



September 09, 2006 17:13:03 #5
 dontbuckme   Member Since: September 2006    Total Comments: 8 

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.

     

 

Back To Question