EXACT USE OF COMMIT EVERY IN TOracleOutput

One Star

EXACT USE OF COMMIT EVERY IN TOracleOutput

Can some one tell me what is the use of commit every in tOracleOutput??
I have set that to 10 and ran the job and it is not populating anything in target even though the records are available in source .
One Star

Re: EXACT USE OF COMMIT EVERY IN TOracleOutput

Hi
The option "Commit Every" is used to ensure transaction quality and performance.
The issue you got is not due to "Commit Every".
There must be other wrong points.
Regards,
Pedro
Seven Stars

Re: EXACT USE OF COMMIT EVERY IN TOracleOutput

To see why records are being rejected by the target, disable "Die on error" and "Use batch size" on tOracleOutput then connect a reject flow from it.
One Star

Re: EXACT USE OF COMMIT EVERY IN TOracleOutput

Still not clear.... if i set commit every to 10 records will it only populate 10 records in the target or it will populate all the records but commit 10 records at a time??
Seven Stars

Re: EXACT USE OF COMMIT EVERY IN TOracleOutput

The latter but possibly commit each 10 records sent to tOracleOutput at a time not each 10 records accepted by Oracle i.e. if 9 out of 10 reject, 1 will be committed each time.
One Star

Re: EXACT USE OF COMMIT EVERY IN TOracleOutput

What is the best no of records that we can commit when we have large size source xml files,by default it comes with 10000 records in tOracleOutput??