This content has been marked as final. Show 5 replies
I dont think it will work. CDC will capture if you do any DML operation on the journalized table. In 1st run uncheck the option and run it. So initial data will be loaded.
After that it will start capturing everything.
Because I have almost 100 interface and each interface 30 data set. Because i don't want to uncheck and check, it will take lot of time. :-(
Are there any other way?
Another way is copy these source data to another table ( duplicate).
If you have 10 source table and then create another 10 duplicate tables in backend.
Now truncate these original tables.Then insert those data from duplicated table to original table. Now CDC will detect them as these are inserted.
But i guess you have more than 300 tables which is again difficult to handle.
Yes, I think it is good idea for me. But it will take time.
Maybe i can duplicate my interfaces. One is bulk load, one is CDC.
Thank you very much,
Just go and update a column to itself on the source tables, this will force it through the CDC, no need for delete / insert.
update table set column=column;