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.
Oracle stage
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers