TOPICS DISCUSSED
AGGREGATOR TRANSFORMATION
1. ACTIVE TRANSFORMATION AND CONNECTED
2. USED TO GROUP THE DATA AND
PERFORM AGGREGATED CALCULATIONS
EX: SUM,MAX,MIN,COUNT,AVG
3. IS ALSO USED TO REMOVE DUPLICATES
4. DEFAULT BEHAVIOUR WHEN YOU DONT USE ANY GROUP BY PORT IN
AGG TRANSFORMATION IT WILL CONSIDER ALL THE RECORDS AS
ONE SINGLE GROUP AND LOAD THE LAST RECORD INTO
TARGET TABLE
PERFORMANCE POINTS
5. ITS ALWAYS GOOD TO SEND SORTED INTO AGGREGATOR TRANSFORMATION
6. ITS ALWAYS SUGGESTED TO DO SORTING ON THE GROUP BY PORT THAT WE WANT TO US IN THE AGGRGATOR TRANSFOMRATION
