Re: DWH concept, what is better ?

Hi John !

my live database is my source database !

my problem is i don't have any experience with DWH ;-(

we are using oracle 9i on unix.

thx

TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<emuq2vcfpskotc9686137t9p87nr1jf94g_at_4ax.com>...
> 1: Try to avoid cross-posting.
>
> 2: By 'live' do you mean the source database or the warehouse one?
>
> 3: Why not load from the live, transform as needed, and load into he DW using a good ETL tool that should be able to do
> it in stages with out using exp/imp at all..
>
>
>
> ora_kimo_at_yahoo.de (Kimo) wrote:
>
> >Hi....
> >
> >In order to extract, transfer and load to our Data Warehouse we have
> >created 2 concepts,
> >1- export the needed data to temporary tables on the live database and
> >then transfer and load the data into Data Warehouse.
> >2- export the data to temporary tables on a separated database and
> >then transfer/load the data into DWH.
> >
> >we concept would you recommend me and can anyone tell me the
> >advantages and
> >disadvantages of each concept ?
> >
> >You can also tell me if you have another option !
> >
> >thanx
> >kimo
Received on Wed Jan 22 2003 - 03:23:43 CST