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
How to remove warning from aggregator stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 57
- Joined: Tue Jun 30, 2009 9:38 am
Re: How to remove warning from aggregator stage
try Default to decimal output property
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.
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.
-
- Participant
- Posts: 53
- Joined: Fri Apr 18, 2008 8:13 am
- Location: United States
How to remove warning from aggregator stage
Hi,
Try using a Modify Stage to convert the Int into Decimal. This should help solve your problem.
Regards,
Ajay
Try using a Modify Stage to convert the Int into Decimal. This should help solve your problem.
Regards,
Ajay
Regards
Ajay
Ajay