Insert into Dynamic RDBMS stage

Diya · Post by **Diya** » Tue Sep 12, 2006 9:03 am

Hi,

I have to insert records into a dynamic RDBMS stage.

Since the derivation logic for one column is different I have to use another link for it.

Is there a way to merge this column along with the other columns and insert into the DRS stage.

It seems like the 'merge' stage will not work.

can anyone help me on this

Thanks,
Diya

thumsup9 · Post by **thumsup9** » Tue Sep 12, 2006 9:34 am

Diya,

stage variables might help here. Can you please make your question a little clear.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 12, 2006 4:31 pm

It would be much easier to solve if you could find some mechanism for deriving this rogue column somewhere in the main stream. There is no way to accomplish that you ask, except for a second job that updates the target via the Dynamic RDBMS stage.