aggregator max(col)

[Mallayagari]

I need to calculate max of decmial(31,0) in aggregator stage. The output is also defined as decimal(31,0). But the output is truncating the values. Is there any limitation(length of column) on max function of aggregator????????????????? For small values its working fine.

Thanks in advance

[ray.wurlod]

The Aggregator stage calculates its results as dfloat, as a technique to avoid arithmetic overflow.

But there's another property in the Aggregations folder, called Default to Decimal Output, that defaults (if I remember correctly) to 8,2. This is applied if the data type of the output is Decimal or Numeric.

At the individual column level, you can also set the Decimal Output sub-property of the Maximum Value Output Column property. This also defaults to 8,2.

Use dfloat as your output column data types from Aggregator and convert them explicitly downstream.

[kumar_s]

Truncation in what factor?
Is it rounding off values or striping of few characters?

[csrazdan]

For 7.5.1 there is a patch available. The aggregator stage provides a Preserve Type option which tells the operator to preserve the type of the input column to output column (in support of min/max) always creates (shows) an output column of type Double, which is incorrect. The user need to go into the Output Columns tab and correct this data type. IBM has logged this as an s-case to fix the bug in the UI and will add it to the next release

[kumar_s]

"s-case" - Is there any new options available.

[csrazdan]

s-case is support case. Since patch is already available that is way it is support case otherwise it will be engineering case.

[kumar_s]

s-case is support case. Since patch is already available that is way it is support case otherwise it will be engineering case.

Oh, thanks.