Aggregator

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
priyaram
Charter Member
Charter Member
Posts: 16
Joined: Fri Apr 23, 2004 7:39 pm

Aggregator

Post by priyaram »

Hi
I am using aggregator stage in my sample job , getting 2 inputs as no,sno
and i am using grouping keys as no and using sum output column for sno

i try to sum the sno column.
i am getting the following warning msg:
' When binding output interface field "SNo" to field "SNo": Implicit conversion; from source type "dfloat" to result type "int32": Possible range/precision limitation '
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

It's just telling you that you might face number truncation or loss of decimal places when your SNo field is aggregated and delivered to an output field. You are aggregating a floating point number into an integer. Floating point fields are capable of holding very large or very small numbers via the scientific notation. I believe they support numbers from 1,000,000,000,000 to 0.0000000000000001.

If you know for sure that your input numbers are never that large or that small you can ignore the warning, otherwise you can adjust your output fields to also be a float field.
Post Reply