Best method to track deleted records on source in Oracle
2 posters
Page 1 of 1
Best method to track deleted records on source in Oracle
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?
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
Re: Best method to track deleted records on source in Oracle
You can use Oracle Streams to track delete in source oracle table.
rgupta614- Posts : 1
Join date : 2010-10-06
Similar topics
» How to handle situations where the data is deleted from the source system?
» create a new record in a SCD2 for a subject that was deleted in the source system
» How to handle SCD type 2 changes - when source records are archived?
» Best method for incremental fact load (inserts and updates) using SSIS
» ETL to handle deleted reference data
» create a new record in a SCD2 for a subject that was deleted in the source system
» How to handle SCD type 2 changes - when source records are archived?
» Best method for incremental fact load (inserts and updates) using SSIS
» ETL to handle deleted reference data
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum