DSXchange

Hi All,

I am getting a warning message with Aggregator stage for the Input field Decimal(15,3) when It is populated to output field Decimal(21,2) after the summation.
The warning message is:
Agg1: When checking operator: When binding output interface field "IMTRANSA_CLAIM" to field "IMTRANSA_CLAIM": Implicit conversion; from source type "dfloat" to result type "decimal[21,2]": Possible range/precision limitation

Any Idea on how to overcome this warning message?

Many Thanks,
Sandeep S Pendem

Declare the output column to have data type dfloat.

Hi Ray,

Thanks for your answer It worked out for the warning message but I am getting a new warning message as :

Agg1: When checking operator: When binding output interface field "IMTRANSA_CLAIM" to field "IMTRANSA_CLAIM": Converting nullable source to non-nullable result; fatal runtime error could occur (use modify operator to specify value to which null should be converted)

How to overcome this?

Many Thanks,
Spendem

Make the field either nullable or non-nullable consistently (both sides of the Aggregator stage and elsewhere in the job).

More generally, don't do anything that annoys the product.