The JOB every hour brings me a different result

igorbmartins · Post by **igorbmartins** » Mon Dec 21, 2009 4:45 pm

Friends, I am here again with other doubt with aggregator.
I have a column containing a value 1 to 30. I want to get the average value. The correct result is 15,50 but the JOB every hour brings me a different result as 15,49 or 15,50 or 15,51.

Anybody know explain me what is happing?

ray.wurlod · Post by **ray.wurlod** » Mon Dec 21, 2009 5:56 pm

Probably rounding when converting from dfloat to decimal. Remember that dfloat can not be accurately stored.

If you want accurate, consistent results, use the Preserve Type option (if using version 8.1).

rajeshananthapalpu · Post by **rajeshananthapalpu** » Tue Dec 22, 2009 9:42 am

Before aggregator, you need to select hash partition with correct partition keys if you are using multinode config file..

priyadarshikunal · Post by **priyadarshikunal** » Tue Dec 22, 2009 10:27 am

try converting it to decimal(10,4) and then apply decimaltodecimal() to convert it to 5,2.

chulett · Post by **chulett** » Tue Dec 22, 2009 10:34 am

Preserve Type exists as an option in the 7.5.2 release. You also have the Default to Decimal Output option that may help as well.

igorbmartins · Post by **igorbmartins** » Tue Dec 22, 2009 10:53 am

My server version is 7.5.1.A
I do this, I setting the Default output to 5,2.

I setting the partitioning hash in the transformer before of the aggregator.

DSXchange

The JOB every hour brings me a different result

The JOB every hour brings me a different result

Re: The JOB every hour brings me a different result