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.
Aggregator issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu Jun 26, 2008 6:13 am
- Location: chennai
Aggregator issue
ramkarthik
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
This alert may be ignored, and therefore is safe to demote to informational using a message handler.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 27
- Joined: Thu Jun 26, 2008 6:13 am
- Location: chennai
For Integer Column
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
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
ramkarthik