We hae a database on MYSQL and we have to integrate it with Oracle 10g database.We are using Oracle Data Integrator 11g to replicate from MySQL to Oracle. We are using IKM=Oracle Incremetal Update.
It is working fine, now the issue tis that if a record is delete from source table it has no impact on target table. We want to to delete the records from targets that werere deleteed from the source.
Please could you guide me in this regards.
We are using
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)
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.