Re: Snapshot of source data for a datawarehouse

In a nutshell, replicate the source systems. Put a timestamp on each row at the target end. Use the replicated database(s) to feed the DW.

Just one idea for a possible solution.

Jared

On Thu, 4 Jan 2001, [iso-8859-1] paquette stephane wrote:

> 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!
> http://photos.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) Received on Thu Jan 04 2001 - 12:55:42 CST