shanthi

• Aug 6th, 2006

 

By using sorter transformation before the aggregator transformation.

sunil

• Aug 9th, 2006

 

by using sorted input

kiran

• Aug 9th, 2006

 

 hi ,

  we can improve the agrregator performence in the following ways

 1.send sorted input.

 2.increase aggregator cache size.i.e Index cache and data cache.

 3.Give input/output what you need in the transformation.i.e reduce number of   input and output ports.

sravan

• Sep 14th, 2006

 

IN Aggregator transformations select the sorted input check list in the properties tab and write sql query in source qulifier.Its improoves the performance.

calltomadhu

 Profile Answers by calltomadhu 

• Sep 23rd, 2006

 

Hi,

we can improve the aggrifation performance by doing like this.

create group by condition only on numaric columns.

use sorter transimition before aggregator

give sorter input to aggreator.

increate the cashe size of aggreator.