You are not logged in.
I have a tOracleOutput that I need to commit every 10000 records updated. I saw there is an option that does it but if I connect my tOracleOutput to a tOracleConnection, the option disappeares and I can just flag automatique commit on the tOracleConnection. It seems that this kind of option commits every record updated but I would like to do it every 10000 or another value I want to choose.
Is there any way to do it?
The tOracleConnection and the commit every n records feature can't be used together, if you use tOracleConnection to create the DB connection, there always be a tOracleCommit to commit the change at the end of job.
and if I have got 3.000.000 di record to update? The buffer would get full before commiting my work and the job would break. In this case I have to avoid using a shared connection?
Yes, you need to create the db connection on the db output component.