sum of column in Aggregator stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kamesh
Participant
Posts: 72
Joined: Tue May 27, 2003 1:47 am

sum of column in Aggregator stage

Post by kamesh »

I have 72k records with decimal 23,3 values in db2 table. I am getting 'A' value when i sum the column using sql query. but when i try to sum the same column field (decimal 23,3) using aggregator i am not able to get the same result.
Can anyone help me out on this issue
Thanks
kamesh
sandy
Participant
Posts: 24
Joined: Sun Feb 01, 2004 1:14 am

Post by sandy »

Is the precision of the summation wrong or the value itself is wrong??
Can you eloborate more, or give more inputs.

Regards,
Sandyla.
RSchibi
Participant
Posts: 8
Joined: Mon Apr 19, 2004 6:13 am

Post by RSchibi »

Just like Sandy, I am also a penny off on some of the amounts that I sum with the aggregator. It's not the same field all the time. After I load my DB2 table & do sums with SQL, the amounts are correct. These are decimal (13,2) fields.

Does anyone have any idea what causes this.
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

Post by Sreenivasulu »

Problem of incorrect Aggregation is very critical functional issue.
We found a solution after a trying a lot of combinations.
Mark as key only the "Group" columns. Rest of the columns
should neither be key nor be marked as "Group
elavenil
Premium Member
Premium Member
Posts: 467
Joined: Thu Jan 31, 2002 10:20 pm
Location: Singapore

Post by elavenil »

Hi Kamesh,

We are facing the same problem. What i understood from PX job was, AGGR stage uses FLOAT datatype when it aggregates the column value and DB2 aggregation does not change the datatype and the results are different when you use AGGR stage.

Hope this would help.

Regards
Post Reply