Thanks for the question, Manasa.
Asked: February 06, 2019 - 5:53 am UTC
Last updated: February 06, 2019 - 9:53 am UTC
Version: 12C
Viewed 1000+ times
You Asked
Hi Tom,
I have a view created daily on a detailed table set ( n number of tables based on the load) as below
CDR_Detail_20190204_view
CDR_Detail_20190205_view
CDR_Detail_20190206_view
To generate a report , i need to pick all the daily views(Currently holding views for 90 days in the database) and report them.
I am trying to build a datawarehouse for the reporting purpose and hence trying to load a table from these views as source
The issue I have here is the table is loaded as soon as view is generated daily but I am not able to track CDC from these views for datawarehouse to be up to date
Any thought on how to achieve this?
and Chris said...
By CDC you mean Change Data Capture, yes?
If so, it depends on how you're doing this. If you're using a tool like GoldenGate that reads redo logs, then you can't do CDC against the views. The redo logs record changes to the base tables. So you need to map your views to the tables and capture these changes.
If you've got DIY solution where you're running a query that loads rows since the last load date, you'll need to expose inserted/updated dates in your views.
I don't understand why you're creating these views. So to give more meaningful help we need to know why you're doing this. And what method you plan on using to do CDC.
Is this answer out of date? If it is, please let us know via a Comment