Please could you guide me in this regards.
We are using
- ODI 11g.
- IKM=IKM Oracle Incremental Update
- JKM=JKM MySql Simple
I did following (it works for Insert and update but not for delete. I mean if I delete a record from Student table in mysql and execute the interface the record is not deleted from Student table in Oracle database).
1.Created a new table in mysql and oracle i.e. Student (id, name)
2.Created a Model for source (Student datastore MYSQL)
- Add to CDC
- Start Journal
3.Created a Model for target (Student datastore Oracle)
4.In the IKM Set the SYNC_JRN_DELETE=Yes
5.In the interface selected the JRN check box
Please guide me if I am missing something.
Thanks in advance.
I am running into the same problem. Update and insert work fine but delete is ignored. Deleted records are captured in the journal but not updated in the target. I am using IKM Oracle Incremental Update with SYNC_JRN_DELETE = true. I have also create separate mappings to do just delete but still to no avail.
Can you tell me how you solved yours?
your help is much appreciated.
If you are not dealing with a big table or recording any control attribute (like load datetime or ODI session id) into the target table.
The best approach for me would be a Control Append with a truncate in the target table. It may save some time and no need to setup CDC.
Also, you can implement a DELETE Option in the Incremental Update KM and avoid CDC.
I would do one of those option if I have to load this table only once a day or weekly.
If you need to have a more real time load then the CDC is the best approach.
My two cents.