to improve the performance of aggregator we use sorted input option and use sort

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

Question Posted / rakeshm4119

3 Answers
7246 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggrega..

Answer / koti

To do aggr. caliculations function it needs some time.. we
can reduce that time by providing sorted I/P. The time is
less which can takes to forward the rows from sorter to
aggregator rather than the time to do aggr. calculations
without sorted data.....

Is This Answer Correct ?

2 Yes

0 No

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggrega..

Answer / bhupal

if u wont use the sorted input the aggregator transformation will reads the records and keep until all the calculations are done.

if we provided the sorted input it reads the records and release the records reaching next first record of new group.
the integration service will creates the cache for only the sorter keys and only one cache in sorter t/r. so by providing the sorted input we get the performance advantage.

Is This Answer Correct ?

1 Yes

0 No

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggrega..

Answer / james

Sorted input in an aggregator transformation does not use
cache instead it uses the memory. Reading from memory is
faster than reading from cache.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer