This discussion is archived
2 Replies Latest reply: Nov 27, 2012 12:28 AM by Bhabani Ranjan RSS

Commit in procedures after every 100000 records possible?

Prerna Vij Newbie
Currently Being Moderated
Hi All,

I am using an ODI procedure to insert data into a table.

I checked that in the ODI procedure there is an option of selecting transaction and setting the commit option as 'Commit after every 1000 records'.
Since the record count to be inserted is 38489152, I would like to know is this option configurable.

Can i ensure that commits are made at a logical step of 100000 instead of 1000 records?

Thank You.

Prerna

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points