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
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.
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
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.