Commiting Records after every record Commiting Records after every record rajipillai (Programmer) (OP) 27 Sep 05 12:15 I want to commit records after every record in a map. Now the transformation encounters error after n records it roll backs all the records from the oracle database. RE: Commiting Records after every record mswitzer (Programmer) 29 Sep 05 15:36 For standard Oracle Target Adapters, you should have a Target Property called CommitFrequency. Set it to 1.For Oracle Multimode Target Adapters, you will have to use an AfterEveryRecord, SQL Statement Action to issue the commit yourself. RE: Commiting Records after every record rajipillai (Programmer) (OP) 29 Sep 05 19:20 Thank you for your help. I am using multimode connection. In the aftereveryrecord am using clearinsertmaprecord method and specifying the table name. I am not opening a ADO connection here and inserting the records to commit record. So how do i handle the commit? RE: Commiting Records after every record mswitzer (Programmer) 30 Sep 05 11:55 SQL Statement is an action, just like ClearMapInsert Record is an action. So, click in the blank cell below your ClearMapInsert Record action, then click on the ellipses button that appears (...). Then, from the drop-down list of actions, choose "SQL Statement". In the "SQL statement" parameter you can enter pure SQL. In your case, enter "commit;"