Re: data warehouse load question

Your "binary unload-load" option is called Export-Import in Oracle. Read about it please in the Utilities manual at tahiti.oracle.com. If performance is an issue, and you can create flat files with your data, a direct-load SQL*Loader run might be your answer. Read about it in the same manual.

Daniel

> 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
Received on Thu Aug 07 2003 - 15:24:18 CDT