Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Snapshot of source data for a datawarehouse

Snapshot of source data for a datawarehouse

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Thu, 4 Jan 2001 02:41:29 -0800 (PST)
Message-Id: <10731.125689@fatcity.com>


Hi,

In the insurance business, the datawarehouse is feedeed by 3 other applications.
The data needs to be captured after the accounting closure and before any other change, the users want the status of the contracts at each end of the month
(like in managing inventories).

The source applications only have the current status
(no history).

Our fear is what if the feeding of the DW doesn't work in the appropriate time window ? The feed is on a monthly basis for now.

I have 4 solutions to keep the data at the accounting closure time in case of feed problems.
1. Have a backup of the source DB and recreate them temporary in order to feed the DW
2. Have a permanent copy of the source DB 3. Have a copy at the accouting closure time of the needed tables in the source DB
4. Have a copy at the accouting closure time of the needed tables in the DW.

Any other solutions ? What are you doing ? TIA



Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online! Received on Thu Jan 04 2001 - 04:41:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US