| Identification of DELETE record from REDO Logs [message #503311] |
Thu, 14 April 2011 05:02  |
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
|
Member |
|
|
Hi,
We are using Oracle CDC to transfer data from SOURCE to STAGING Database.
Purging the data after 3 days from STAGING database.
From Staging Database we generate the data file.
If any data is coming after 3 days than using MERGE principle in data file to make the data consistency for INSERT and UPDATE operation.
But for DELETE operation, which happens after 3 days. ????
How track DELETED records as it will not find the data in STAGING database?
Is there anyway to identify the DELETED records in REDO logs or else any suggestion?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
