Page 1 of 1

Aggregator issue

Posted: Tue Aug 12, 2008 3:48 am
by ramkarthik
Hi,

I am getting a warning message while finding the max value of
a bigint datatype column in aggregator stage.I used double datatype for output column

Warning:
Aggregator_17: When checking operator: When binding input interface field "Column2" to field "Column2": Implicit conversion from source type "int64" to result type "dfloat": Possible precision loss.

Posted: Tue Aug 12, 2008 4:32 am
by ray.wurlod
All calculations in Aggregator stage work in dfloat. That is the source of the alert message. Have you set the Decimal Output property for this particular field, or globally in the Aggregator stage?

This alert may be ignored, and therefore is safe to demote to informational using a message handler.

For Integer Column

Posted: Tue Aug 12, 2008 7:40 am
by ramkarthik
No

I have not set the decimal output property globally and specifically to that field but when calculating the max value of an integer datatype column it was working fine(without any warnings).Output column(max of Column2) is in double(dfloat) datatype