Replacing Existing Rows
Posted: Thu Mar 16, 2006 9:02 pm
Hi,
I want to use Replace Existing rows completely in update action. To achieve this do I need to have same value for key columms and I have only one link to the DB2 / API stage . How can have two links for delete and insert for single stage. Please help me how to achieve this option from transformer to DB2 stage.
Thanks,
Somaraju
I want to use Replace Existing rows completely in update action. To achieve this do I need to have same value for key columms and I have only one link to the DB2 / API stage . How can have two links for delete and insert for single stage. Please help me how to achieve this option from transformer to DB2 stage.
Thanks,
Somaraju