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.
Aggregator stage properties.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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.