Re: DWH concept, what is better ?

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 Tue Jan 21 2003 - 10:54:54 CST