Oracle Enterprise Commit

[dsean]

Hi all,
I am loading the data into an oracle table using Oracle Enterprise stage and I set the $APT_ORAUPSERT_COMMIT_ROW_INTERVAL to 2000 rows for the first time. Is it possible to change the number of rows to commit to 3000 in the next load during runtime?

Thanks in advance
Sean

[Minhajuddin]

Yes, To be able to change the transaction size i.e. the commit interval, you will have to add this environment variable in the job parameters.