DSXchange

Hi All,

I am getting below warining message and I have delcared as numeric

When checking operator: When binding output interface field "DUPLICATE_REC_COUNT" to field "DUPLICATE_REC_COUNT": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation.

Please help me on this ,how to resolve.

Thanks and Reagrds
Srini

By not mapping a dfloat (which can be an extremely large number) into an int32 (which can't be bigger than about 2,700 million).

ray.wurlod wrote:By not mapping a dfloat (which can be an extremely large number) into an int32 (which can't be bigger than about 2,700 million). ...

i din't understand plz explain

Somewhere there is a large number mapped to a smaller number and it won't all fit. Typically this happens with Aggregator output which, if not explicitly handled, will output its results in dfloat format.

Hi All,

I am getting this warning message if using Aggregator stage output in 8.1

When checking operator: When binding output interface field "DUPLICATE_REC_COUNT" to field "DUPLICATE_REC_COUNT": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation.

All the places data tpe is interger(10)

Please help me on this

Thanks and Regards
Srini

But it's dfloat within the Aggregator stage.

Investigate the Decimal Output property and the Preserve Data Type property.

When performing an aggregation using the aggregator stage,the output column's datatype will be dfloat by default(internally) though you have mentioned the DUPLICATE_REC_COUNT field's datatype as Integer(10) .
So, mention the aggregation field's output datatype as Double(20) and then use a transformer stage to convert it to integer 10.Else this warning will occur.