Question regarding Sort and Partitioning
Posted: Mon May 11, 2009 12:59 pm
When would we implement a sort routine prior to the aggregator? I know that if the aggregator input tab partitioning is set to Auto, Datastage takes care of the sorting and grouping. What concerns me is the documentation. It states that we should sort and repartition the data prior to the aggregator. Is it really required because the Director log states a sort and grouping is done on the keys that are selected. I have test both mechanism and they both send back the exact same data.
Is repartitioning only used with the duplicate and join stages.
Could some please elaborate.
Thanks
Is repartitioning only used with the duplicate and join stages.
Could some please elaborate.
Thanks