Aggregator Error

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
reddy12
Participant
Posts: 99
Joined: Tue Aug 08, 2006 9:34 pm

Aggregator Error

Post by reddy12 »

Hi,

In my i need to aggrigate some fields.There are 4 fields are there in source .for that i am using aggregator stage.in this aggrigator stage i have to take like this

Fields AAAAA
Min(DATE)
Min(BBBBB)
Sum(CCCCC)
Source have these 4 fields

I created job but i am getting below error. Please help me.

Aggregator_1: Error when checking operator: When binding input interface field "DATE" to field "DATE": No default type conversion from type "timestamp" to type "dfloat".
reddy12
Participant
Posts: 99
Joined: Tue Aug 08, 2006 9:34 pm

Re: Aggregator Error

Post by reddy12 »

Fields AAAAA
Min(DATE)
Min(BBBBB)
Sum(CCCCC)
Source have these 4 fields
Group By AAAAA.
reddy12 wrote:Hi,

In my i need to aggrigate some fields.There are 4 fields are there in source .for that i am using aggregator stage.in this aggrigator stage i have to take like this

Fields AAAAA
Min(DATE)
Min(BBBBB)
Sum(CCCCC)
Source have these 4 fields

I created job but i am getting below error. Please help me.

Aggregator_1: Error when checking operator: When binding input interface field "DATE" to field "DATE": No default type conversion from type "timestamp" to type "dfloat".
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Thispost may help.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
reddy12
Participant
Posts: 99
Joined: Tue Aug 08, 2006 9:34 pm

Post by reddy12 »

I am not getting clear idea about this? Can you please give me brief details?
DSguru2B wrote:Thispost may help.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Click on the blue link (This) that I provided in my previous post. Basically for aggregation a dfloat is required. That link gives a step by step method by Kumar on how to get it done.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply