DSXchange

Hi
I have a job design I have 2 sepetate jobs .One for insert into DB2 table and another for delete into DB2 table.
I want to delete or insert DB2 table based on Key feild in Seqfile.

I want to know whether i have to use target table as lookup and match on key feild and do insert or delete.

please share your thoughts
thks
sai

If you want to delete only the records based on key field and insert new ones then you can choose update action "Replace existing rows completely" or do a simple update based on the key.

Otherwise two output links from the Transformer stage, each into the DB2 stage. One link manages the deletes, the other manages the inserts.