DSXchange

We are loading multiple Teradata tables through a single job.
While loading if the job fails then all the records which were inserted in the other tables in the same run should be rolled back. .i.e either all the records should be inserted in all the tables or no records should be inserted in any of the table at all.
Please suggest which stages to be used in DataStage Server job to achieve the same

Distributed Transaction Stage, once they enable it for use with Teradata.

Until then it has to be "roll your own" back!

Hi Ray,

Can't we use Teradata Multiload Stage and using 1 stage for 1 table within my job. I mean to say if there are 3 tables to be populated using the same job, I will use 3 stages within the job.

That's fine, but it does not give you any rollback capabilities on the set of tables. You have to design another job to "undo" committed transactions on the other tables.