Page 1 of 1
sum of column in Aggregator stage
Posted: Wed May 05, 2004 4:33 am
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
Posted: Sat May 08, 2004 1:06 am
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.
Posted: Wed May 19, 2004 6:34 am
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.
Posted: Fri Jun 11, 2004 12:55 am
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
Posted: Wed Jun 23, 2004 11:45 pm
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