topic Re: EXACT USE OF COMMIT EVERY IN TOracleOutput in Talend Studio

EXACT USE OF COMMIT EVERY IN TOracleOutput

Anonymous — Mon, 06 Aug 2012 17:09:31 GMT

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 .

Re: EXACT USE OF COMMIT EVERY IN TOracleOutput

Anonymous — Tue, 07 Aug 2012 03:23:36 GMT

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

Re: EXACT USE OF COMMIT EVERY IN TOracleOutput

alevy — Tue, 07 Aug 2012 08:28:16 GMT

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.

Re: EXACT USE OF COMMIT EVERY IN TOracleOutput

Anonymous — Tue, 07 Aug 2012 09:48:16 GMT

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??

Re: EXACT USE OF COMMIT EVERY IN TOracleOutput

alevy — Wed, 08 Aug 2012 00:37:44 GMT

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.

Re: EXACT USE OF COMMIT EVERY IN TOracleOutput

Anonymous — Thu, 16 Aug 2012 10:59:47 GMT

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??