Hi Jared,
Your idea corresponds to the solution 2.
I was hoping not to duplicate the environments
especially as the dev team came to me with that
problem 2 weeks before production.
Anybody out there working with a DW managing inventory
style data ?
- jared still <jkstill_at_teleport.com> a écrit : >
> 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
> ;)
> jkstill_at_teleport.com
> jared_still_at_enron.net
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: jared still
> INET: jkstill_at_teleport.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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Received on Mon Jan 08 2001 - 03:23:26 CST
