Page 1 of 1
Oracle stage
Posted: Wed Sep 17, 2008 5:23 am
by svga
Hi,
How can i rollback the entire data that lodaed into the oracle table if my job gives warning? As of now my job commit the data till it encounterd error.
Posted: Wed Sep 17, 2008 5:31 am
by shaimil
Take you a look at the transaction handling tab. Set the rows per transaction to 0 to do a single commit.
Posted: Wed Sep 17, 2008 6:07 am
by svga
Even after Row per Transaction set to 0 its rejects only error records and just leave the warning in the director. but correct records got committed.
Posted: Wed Sep 17, 2008 7:27 am
by chulett
The job must abort for any rollback to happen. You need to make sure this happens by setting a very low warning threshold, a reject link set to abort after 1 record, using the 'treat warning as fatal' option in the OCI stage, etc etc.