2 Replies Latest reply: Feb 7, 2014 10:25 AM by user5716448 RSS

    owb - matching on and updating same column at same time - possible in mapping?



      Could do this in sql update statment as per below but owb generates merge for updates and cannot match on key and update at same time.


      Using oracle



      UPdate  table

      set columna = to_date('20/05/2009','DD/MM/YYYY')

      where columna = to_date('19/05/2009','DD/MM/YYYY')


      What is best way to do this in owb mapping?


      Mereg statemnet cannot be generated because column is used for both matching and update