Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Best method to track deleted records on source in Oracle

Go down

Best method to track deleted records on source in Oracle Empty Best method to track deleted records on source in Oracle

Post  dellsters Thu Sep 23, 2010 11:56 am

We need a way to track deleted records from the source tables in Oracle. We have one source Oracle database and our data warehouse is also in Oracle. I'm somewhat familiar with CDC (asynchronous would do the job) to tap into the logs, but is there anything else in Oracle I could use?
Any ideas of best practices? I only have a few of them. Like 30 records per month. What is the best option?

I heard of a materialized view log being enabled in the source log. The materialized view in the target and do a fast refresh from the mv log in the source (replication using snapshot). It sounds like the same thing as CDC, but anybody heard of this?

dellsters

Posts : 39
Join date : 2009-02-11

Back to top Go down

Best method to track deleted records on source in Oracle Empty Re: Best method to track deleted records on source in Oracle

Post  rgupta614 Wed Oct 06, 2010 10:43 am

You can use Oracle Streams to track delete in source oracle table.

rgupta614

Posts : 1
Join date : 2010-10-06

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum