We are using IBM Infosphere CDC for replicating data from Source to target. We have a query in using this tool, i.e. is there any way or option to insert a new row into the target table instead of just overwriting the change.
For e.g:
1. Lets suppose that emp1 and emp2 are the source and target tables.
2. These have columns eno, ename.
3. On first replication process, all the data is moved to target.
4. Now, the data in the existing records is modified like ename is modified from "abc" to "def" in an existing record.
5. When we again run the replication process, the record is getting overwritten with "def" in the target table.
Our requirement is such that a new record should be inserted in the target table with the changes, instead of overwriting the existing record.
Any help or pointers on this would be highly appreciated.
Thanks,
Siva
Tags
Use the search field to
find all types of content in My developerWorks with that tag.
Use the slider bar to see more or fewer tags.
Popular tags shows the top tags for this particular type of content or application that you're viewing.
My tags shows your tags for this particular type of content or application that
you're viewing.
