DSXchange

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

Diya,

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

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.