Oracle stage

svga · Post by **svga** » Wed Sep 17, 2008 5:23 am

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.

shaimil · Post by **shaimil** » Wed Sep 17, 2008 5:31 am

Take you a look at the transaction handling tab. Set the rows per transaction to 0 to do a single commit.

svga · Post by **svga** » Wed Sep 17, 2008 6:07 am

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.

chulett · Post by **chulett** » Wed Sep 17, 2008 7:27 am

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.