AGGR inconsistency running PX 7.5.1
Posted: Wed Apr 20, 2005 6:55 am
I am sorting by 36 columns, grouping the same 36 columns, partitioning by 3 of the sorting columns i.e 3 columns (sort+parition).
Performing sum calculation on 7 other columns.
I have not checked the key on any columns in the column window.
Each time I run I have different no. of rows outputted from the aggregator stage.
Pl. help. How could I have the same no. of rows outputted everytime I run.
I am using 8 CPUS.
The same problem is giving me different values in the sum columns when I total them up in an excel sheet. Ofcourse because each time difft no. of rows are being outputted.
Thanks.
Performing sum calculation on 7 other columns.
I have not checked the key on any columns in the column window.
Each time I run I have different no. of rows outputted from the aggregator stage.
Pl. help. How could I have the same no. of rows outputted everytime I run.
I am using 8 CPUS.
The same problem is giving me different values in the sum columns when I total them up in an excel sheet. Ofcourse because each time difft no. of rows are being outputted.
Thanks.