getting a fatal error in dstage job
Posted: Mon May 12, 2008 4:41 am
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
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