Search code examples
sql-serverdb2etldatastage

How to update a source table after copying data to another database in Datastage?

I have a simple ETL job copying data from MS SQL to DB2 using DataStage. I need to update a column in MS SQL, "SenttoDB2" once I have successfully copied the data to DB2.

I figured that I just need to create another stage after DB2 and pass the "key" from the source in the update SQL to update the column. Is this correct or am I missing a step somewhere?

Solution

  • You could add an after stage update sql to the source DB2 stage. The sql will get written when the data is pulled, but it will be rolled back on job failure.

    If the timing is exceptionally important then you will need to create a second job that updates the source table after the job completes.