2 Replies Latest reply: Nov 27, 2012 2:28 AM by Bhabani Ranjan RSS

    Commit in procedures after every 100000 records possible?

    Prerna Vij
      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.