DSXchange

Posted: **Sun Apr 29, 2012 8:35 am**

Hi,

I have to tune the below job. In both aggrigate stage I want to use hash partition.After that I want to clear the partition.Please correct me If i am wrong.

Code: Select all

                                           Aggr-->Transformer
                                                                         funnel stage---> teradata
teradatstage-->Filter stage --->
                                           Aggri-->Transformer

Posted: **Sun Apr 29, 2012 2:22 pm**

There should be no requirement to clear the partitioning. What specific stage type is the target?

Posted: **Sun Apr 29, 2012 3:28 pm**

Please explain more about the nature of data you are aggregating ..

as Ray mentioned there is no need to clear partitions after aggregation ..

Please give detail information about the job .

DSXchange

Tune the job

Tune the job