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
Insert into Dynamic RDBMS stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.