Re: data warehouse load question

utkanbir wrote:

> Hi Guru's,
>
> What is the best way to load data to datawarehouse from the source system?
>
> Simply ,
>
> 1 . select data from source system to fılesystem
> 2 . load data from file system to the warehouse database
>
>
> Is there any binary unload-load option ? (Like informix - Hpl)
> How can i guarantee all this operations ? (If one fails - do that load again )
>
> I am about the design my sysem for all these things but i will be appreciated
> if anyone can share experience with me before i reinvent the wheel .
>
> Kind Regards,
> hope

Assuming you are talking about an Oracle database ... you don't say. And making assumptions with respect to hardware, operating system, version, edition, file structure, load file size, loading window, number of tables, indexes, etc.

I recommend SQL*Loader in DIRECT PATH mode.

If you want a better answer ... post more information with your question.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)