How to remove warning from aggregator stage

[bhargav_dd]

All

I am getting follow warning, when summing up the column using aggregator
stage. source data type for that colunmn is integer and target datatype is
dedimal 9,2

Aggregator_104: When checking operator: When binding input interface field
"DRAW" to field "DRAW": Implicit conversion from source type "int32" to
result type "decimal[9,2]": Possible range limitation.


Can any body help to fix these

Thanks

[GJ_Stage]

Hi ,

One of way is suppress the warning using Message Handler.

[madhukar]

try Default to decimal output property

[asorrell]

This is a a legitimate warning because an int32 can hold a number up to 2,147,483,648, while a Decimal 9,2 can hold up to 9,999,999.99 (unsigned in both cases).

So what it is saying, is there is a distinct possibility that a number could be truncated.

I do not recommend over-riding the message with the handler. The correct solution is to either reduce your incoming integer to int16 prior to aggregation, or (more appropriately) output the aggregate as a double-precision number that could possibly hold the maximum integer without truncation. You can then route it to a transformer where you can insure the number will fit in a decimal 9,2 field without overflowing after conversion.

[ajay.vaidyanathan]

Hi,
Try using a Modify Stage to convert the Int into Decimal. This should help solve your problem.

Regards,
Ajay