Conversion warning message

naidu · Post by **naidu** » Wed Oct 28, 2009 9:55 am

Hi all
I am getting this warning message and i don't know about "dfloat" can any one help me to remove this warning message. I have migrated this job from 7.5 version to 8.1 version it works fine in 7.5 version no warning messages but in 8.5 it shows the warning message.
Below is the warning message:
Aggregate_Count_of_Extracted: When checking operator: When binding output interface field "TER_CNT" to field "TER_CNT": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 28, 2009 11:21 am

All calculation inside the Aggregator stage are performed as dfloat. Your design specifies an output column as integer data type. This generates the alert messages, because not all dfloat numbers can be stored as integer. Use the DecimalOutput property or Preserve Data Type property to avoid this alert.

naidu · Post by **naidu** » Wed Oct 28, 2009 11:27 am

ray.wurlod wrote:All calculation inside the Aggregator stage are performed as dfloat. Your design specifies an output column as integer data type. This generates the alert messages, because not all dfloat numbers ca ...

Thanks for your reply and what should i do to remove this warning

ray.wurlod · Post by **ray.wurlod** » Wed Oct 28, 2009 11:30 am

Get a premium membership so that you can read the entirety of my post.