5 Replies Latest reply on Nov 13, 2019 7:27 PM by Ollie MS

    Use ODI to automatically remove rows on target

    Ollie MS

      Hello,

      I've been using ODI for a while, namely to add new rows to my target table. The problem is the fact that I can't delete any rows which have been deleted from the source table, which is updated dynamically. Once I delete a row from the source table, the target still has a "ghost row" which I can only substitute once there's a new entry on the source table. It probably has to do with "incremental update", but I'm still a new user, so I'm a bit lost. One person told me I would probably need to use PL/SQL to define a function for the effect, but I'm not sure if there's no easier way.

       

      Thank you for your time.