Database DataWarehousing (MOSC)

MOSC Banner

Incremental replication of OLTP database to Datawarehousing.

edited May 8, 2013 9:22PM in Database DataWarehousing (MOSC) 13 commentsAnswered
We have an OLTP database and everynight that DB is copied to a clone DB for reporting. Now the management want that clone DB to become a datawarehousing DB and they want to retain the data in that DW database for 3 years. They want to replicate the daily delta changes on OLTP database to DW database. The data will be deleted from OLTP daily once the incremental changes have been copied to DW database. We are on 11.2.0.3. Can someone suggest the possible solutions please?

Thanks

Mukul

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center