Generally, we are using Fork n Join method ( divide the data into 2 links which goes to 2 Aggregator ) to calculate Sum and Count Rows of Data because Aggregator Stage is providing one type of aggregation at a time, You can Count the rows or can do some other aggregation.
Here, I have describe a way in which we can Count Rows and Calculate Sum in a Single Aggregator Stage with some limitations :-)
Design :As per design, we used Column Generator and Aggregator Stage to calculate and count.
Source is a DB2 table ( EMPLOYEE) which is having 42 rows having First Name, Last Name, Job, Salary etc. We are simply reading the data from DB2 connector stage.
Column Generator Stage Properties :
In Column Generator Stage, we are generating a dummy column having value 1 each time.
By editing extended properties of "dummy" column we can make datastage to generate always 1 for each row. Now, How you can edit Column Extended Properties
As in above Imgae, you can see the "dummy" column metadata. You need to double click on left most of column ( where is Column Number is written ) for which you want to edit extended properties. Edit n do like below image -
Aggregator Stage Properties
Setup the Aggregate Stage Properties like below -
Grouping Keys -- dummy
Aggregation Type - Calculation
Calculate Sum on - dummy and Salary
as both column is numeric you will get the output you wanted.
Row Count -- Sum of dummy column value which is 1 for each row so -- 1+1+1+.....
Total Salary -- Sum of Salary defined in each row.
Like the Facebook Page & join Group
For WHATSAPP group , drop a msg to 91-88-00-906098