insert data into table that is being populated
Posted: Mon Apr 17, 2006 10:02 am
Hi everyone,
I have a column X that is being populated, in the transformer, after that value has been populated i need to take column X and compare it to another reference table, to populate another column. I tried this so far and i kept crashing datastage. After column x was done i sent that to a hash file and than to a transformer where that was compared to the reference table, than sent back to another hash file where i sent it to the final table but it kept on crashing because the table was already open. If anyone has any suggestion it is greatly appriacated. THANKS
I have a column X that is being populated, in the transformer, after that value has been populated i need to take column X and compare it to another reference table, to populate another column. I tried this so far and i kept crashing datastage. After column x was done i sent that to a hash file and than to a transformer where that was compared to the reference table, than sent back to another hash file where i sent it to the final table but it kept on crashing because the table was already open. If anyone has any suggestion it is greatly appriacated. THANKS