2 Replies Latest reply on Aug 28, 2014 6:45 AM by 2605470

    transaction control in ODI is leading to locks on temporary tables


      Hi All,


      I have a requirement where in i need to ensure that automatic rollback happens when any step fails in the package.

      I have a list of interfaces which loads couple of tables which are linked by foriegn keys.

      so for this case i have set all the DML steps in  IKM oracle incremental update km to transaction1

      Did the same in CKM too.

      Now a lock is happing on all I$ and E$ tables when trying to create a index on these tables.

      The uncommited DML statements executed before this index creation step is the reason for this. Is there a way to perform transaction control without these locks happening in ODI. Please share any inputs on the same.


      Thanks in advance