Rollback transaction on failure in datastage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bj_ds7
Premium Member
Premium Member
Posts: 32
Joined: Fri Dec 13, 2013 2:26 pm

Rollback transaction on failure in datastage

Post by bj_ds7 »

Please advice me a way to keep transaction size as 0 when there is multile iput links to single oracle connector.In one of our job we have a oracle conenctor with two incoming link .Both will do transaction at the same time.Please advice me a way to roll back entire records when there is failure in jobs like unique contrain ,when one of link fail.
Thanks & Regards!
BJ
Post Reply