3 Replies Latest reply: Feb 1, 2013 8:31 AM by Bhabani Ranjan RSS

    Transaction Control in ODI

    udaypratap - oracle
      Hi All,

      I am trying to do the below mention steps

      1. update the status='S' for certain criteria -- No Commit-- Transaction-1
      2. Interface : Transfer Row with status 'S' -- No Commit
      3. Update status='X' for error rows in above step. No Commit Transaction-1
      4. Interface Transfer rows with status 'S' No Commit
      5 . Update the status for successful transfer 'F' and for error rows 'X' -- Commit Transaction-1

      Is this doable, I am not able to hold the transaction of these many steps, ODI start committing with execution of DDL, like drop and create table in interface.

      Any suggestion please, Thanks in advance.