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
MerinaPremaj
Participant
Posts: 4
Joined: Thu Oct 20, 2011 4:33 am

Aggregator Error

Post by MerinaPremaj »

I have a parallel job with transformer and aggregator.
while executing the job,im getting the following error in aggregator.
"No derivation found for column 'poc_id' " but i mapped all the columns from transformer to aggregator.i checked all the derivations but i could not fix it. why is it so?

Thanks.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What 'derivation' do you have for the POC_ID column in the aggregator? In other words, what did you tell the aggregator to do with the field - group by it? Sum it?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply