getting a fatal error in dstage job

[bharatmajeti]

Hi,
my datastage job contains two aggregators, output of the two aggregators are joined in a join stage with 'innerjoin' mode. when i run my job untill this join stage, it runs fine. i kept one transformer stage where i am calculating so many variables based on variables RATESAVG_1,RATESAVG_2,RATESAVG_3........RATESAVG_12. I am getting fatal error "main_program: Fatal Error: Destination "input0Int8RATESAVG_1122" is already bound". I dont have any variable with name "RATESAVG_1122", also my target variable is of type Decimal(13,4) not Int8.

please suggest

[senthilt1]

Hi...

" i kept one transformer stage where i am calculating so many variables based on variables RATESAVG_1,RATESAVG_2,RATESAVG_3........RATESAVG_12."

I am not clear on, " calculating so many variable based on variables", Could you elaborate it bit. Are these 12 variables are calculated based on the output from join stage?

Thanks,

Senthil P

[ArndW]

The first question in cases like this is "do you have RCP enabled?"

[ray.wurlod]

Please post the exact error, using Copy and Paste. What you have provided does not make sense - it is missing at the very least some vital punctuation.