DSXchange

Hi All,

In the Aggregator stage there are properties under the Input page and partitioning tab like choosing the partion type , key field, sort type , stable and unique and on the Stage page and propertied tab..there is an option to Method = sort/hash .. what does this mean??

How does properties on both pages work??

can someone clarify?

Thank you.

These are all clearly explained in the manuals, the on-line help and in the Information Center.

Method allows you to choose the way that the result table is handled, and affects the amount of memory consumed.

• Hash builds a hash table in memory to store results for every combination of grouping keys. However it does not require sorted input.
  
  Sort asserts that the data are sorted by grouping keys, so that only one group at a time needs to be kept in memory. Rows out of order will cause the job to abort.