Aggregator Stage - Warnings

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
devidotcom
Participant
Posts: 247
Joined: Thu Apr 27, 2006 6:38 am
Location: Hyderabad

Aggregator Stage - Warnings

Post by devidotcom »

I keep getting these warning when using an aggregate stage which is been used to either count the number of rows or calculate the sum of a column.

Warning are:

"Aggr_Count_Execution: When checking operator: When binding output interface field "ACTL_PULL_EXEC_Q" to field "ACTL_PULL_EXEC_Q": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation."

"Aggr_Count_Loc: When checking operator: When binding output interface field "Count_Bkrm_Loc_Tran_C" to field "Count_Bkrm_Loc_Tran_C": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation."

"Aggr_Sum_Pull_Q: When checking operator: When binding output interface field "ACTL_PULL_EACH_Q" to field "ACTL_PULL_EACH_Q": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation."
Last edited by devidotcom on Tue Jul 10, 2007 6:09 am, edited 2 times in total.
devidotcom
Participant
Posts: 247
Joined: Thu Apr 27, 2006 6:38 am
Location: Hyderabad

Post by devidotcom »

Apart of using a modify stage after this aggregate stage is there a way to do type conversion. I want the output columns to have Integer type.
Post Reply