Re: data warehouse load question

Hi Daniel,

Thank you very much for your help !

Kind Regards,
hope

danielroy10junk_at_hotmail.com (Daniel Roy) wrote in message news:<3722db.0308071224.425c3a87_at_posting.google.com>...
> 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&#305;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 Fri Aug 08 2003 - 01:00:16 CDT