Aggregator issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ramkarthik
Participant
Posts: 27
Joined: Thu Jun 26, 2008 6:13 am
Location: chennai

Aggregator issue

Post 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.
ramkarthik
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ramkarthik
Participant
Posts: 27
Joined: Thu Jun 26, 2008 6:13 am
Location: chennai

For Integer Column

Post 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
ramkarthik
Post Reply