Praveen Vasudev

• Sep 12th, 2005

 

use sorted input:

1. use a sorter before the aggregator

2. donot forget to check the option on the aggregator that tell the aggregator that the input is sorted on the same keys as group by.

the key order is also very important.

Shivat

 Profile Answers by Shivat 

• Sep 13th, 2006

 

hi,

You can use the following guidelines to optimize the performance of an Aggregator transformation.

Use sorted input to decrease the use of aggregate caches.

Sorted input reduces the amount of data cached during the session and improves session performance. Use this option with the Sorter transformation to pass sorted data to the Aggregator transformation.

Limit connected input/output or output ports.

Limit the number of connected input/output or output ports to reduce the amount of data the Aggregator transformation stores in the data cache.

Filter before aggregating.

If you use a Filter transformation in the mapping, place the transformation before the Aggregator transformation to reduce unnecessary aggregation.

 

Shivaji T

Rksinghpathania

 Profile Answers by Rksinghpathania 

• Jun 26th, 2007

 

Following are the 3 ways with which we can improve the session performance:-

a) Use sorted input to decrease the use of aggregate caches.

b) Limit connected input/output or output ports

c) Filter before aggregating (if you are using any filter condition)

kiran

• Aug 12th, 2007

 

By using Incrimental aggrigation also we can improve performence.Becaue it passes the new data to the mapping and uses historical data to perform aggrigation

talari

 Profile Answers by talari 

• Dec 21st, 2008

 

to improve session performance in aggregator transformation enable the session option, Incremental Aggregation

job_infa

 Profile Answers by job_infa 

• Jan 28th, 2009

 

-Use sorted input to decrease the use of aggregate caches.
-Limit connected input/output or output ports.
Limit the number of connected input/output or output ports to reduce the amount of data the Aggregator transformation stores in the data cache.
-Filter the data before aggregating it.

manoj_behera82

 Profile Answers by manoj_behera82 

• Jul 20th, 2010

 

1. Provide sorted input into the aggregator. Do check the sorted input property in the aggregator.
2. Reduce the input/output ports in the aggregator.
3.Can try increasing the cache size.