Page 1 of 1

Conversion warning message

Posted: Wed Oct 28, 2009 9:55 am
by naidu
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.

Posted: Wed Oct 28, 2009 11:21 am
by ray.wurlod
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.

Posted: Wed Oct 28, 2009 11:27 am
by naidu
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

Posted: Wed Oct 28, 2009 11:30 am
by ray.wurlod
Get a premium membership so that you can read the entirety of my post.