Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: hopehope_123@yahoo.com (utkanbir) Newsgroups: comp.databases.oracle.server Subject: Re: data warehouse load question Date: 7 Aug 2003 23:00:16 -0700 Organization: http://groups.google.com/ Lines: 36 Message-ID: References: <3722db.0308071224.425c3a87@posting.google.com> NNTP-Posting-Host: 195.87.15.131 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1060322416 14314 127.0.0.1 (8 Aug 2003 06:00:16 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2003 06:00:16 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240072 Hi Daniel, Thank you very much for your help ! Kind Regards, hope danielroy10junk@hotmail.com (Daniel Roy) wrote in message news:<3722db.0308071224.425c3a87@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ı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