Answered Questions

  • Sep 20 2004
    06:26 PM
    7752
    18

    What are Aggregate transformation?

    Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: Praveen vasudev

    • Sep 12th, 2005

    Aggregator transform is m uch like the Group by clause in traditional SQL.

    this particular transform is a connected/active transform which can take the incoming data form the mapping pipeline and group them based on the group by ports specified and can caculated aggregate funtions like ( avg, sum, count, stddev....e.tc) for each of those groups.

    From a performanace perspective if your mapping has an AGGREGATOR transform use filters and sorters very early in the pipeline if there is any need for them.

    veepee

    sivakp

    • Mar 13th, 2011

    1. Aggrigator transformation allows to perform aggrigate calculation, such as SUM, MAX, MIN, FIRST, LAST2. Aggrigator transformation allows to perform aggrigate calculation of group.

    shr_4

    • Oct 27th, 2010

    To perform Group by calculations  we use Aggregator Transformation.It perform calculations similar to Expression Transformation.But difference  between both is that Aggregator Transform...