hi ,
I have a req to capture insert, update and delete so I used change capture stage to achieve.
I created three different links to insert, update and delete for same table. Does it create any issues like database/table locks while performing insert/update/delete? if so what are other options ?
I am using DRS stage. Database is oracle10g.
insert, delete and update
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: insert, delete and update
[quote="srao"]hi ,
I have a req to capture insert, update and delete so I used change capture stage to achieve.
I created three different links to insert, update and delete for same table. Does it create any issues like database/table locks while performing insert/update/delete? if so what are other options ?
I am using DRS stage. Database is oracle10g.[/quote]
Thank you Ray. any options ?
I have a req to capture insert, update and delete so I used change capture stage to achieve.
I created three different links to insert, update and delete for same table. Does it create any issues like database/table locks while performing insert/update/delete? if so what are other options ?
I am using DRS stage. Database is oracle10g.[/quote]
Thank you Ray. any options ?
-
- Participant
- Posts: 63
- Joined: Fri Jun 22, 2007 7:27 am
- Location: Kolkata
Re: insert, delete and update
Issue will be there - if the same entity/row is being inserted, updated, deleted - if the same row with same key is in more than one link.srao wrote: Does it create any issues like database/table locks while performing insert/update/delete? if so what are other options ?
How will you gurantee that first instert is done then on that inserted row the update is made? Rethink on this solution
Re: insert, delete and update
The Change capture done in the upstream should ensure that the same tuple is not being propagated on all three links. A long as lock escalations don't happen from Row to Page to Table , deadlocks shouldn't happen. The commit frequency might also play a factor in your job set up.