Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

delete rows in the target table using odi interface

SaiDec 11 2012 — edited Dec 13 2012

Hi gurus,

I am using ODI 11.1.1.5 and my source and target databases are Oracle 11gR2. Is it possible to know delete rows in the target table using odi interface?

The scenario is I have a source table by name 'A' in my source database for which i got 'Read only access', and in some other database I got a table by name 'B' for which I got
'Read and Write' access. At any point the data in the Target table should be mirror image of source table.

I can handle Inserts and Updates, but I don't know how handle delete operations on the source where the expected result is "corresponding records should be deleted in the Target table". I know with CDC I can achieve this but in CDC it creates a trigger and view on source table which is not possible in my case.

Please share your ideas,

Regards,
Sai.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 10 2013

Added on Dec 11 2012

#business-intelligence-applications, #data, #data-integrator, #odi, #oracle, #system-management-and-integration

5 comments

9,690 views