I don't have any white papers or anything, but...
How about SQL*Loading as soon as you get the flat files into some tables in
another database then using transportable tablespaces to move the data into
the datawarehouse?
I would think their are several ways you can preload the data and then
While I don't have a recommendation for a good white paper, let me just
throw out a blatant plug for Jonathan Gennick Sanjay Mishra's book,
Oracle SQL*Loader - The Definitive Guide. This is one book that I
picked up and within just a few minutes was saying 'Wow - I've got to
try that out!'
I
Go at http://www.evdbt.com/papers.htm
You'll find a white paper on sql*loader for DW.
--- Smith, Ron L. [EMAIL PROTECTED] a écrit : We
have an application that calls SQL*Loader to load
data warehouse tables
every night. We would like to speed up
the loads if possible. Does anyone have
Ron,
Please check this out :
http://oracle.oreilly.com/news/oraclesqlload_0401.html
And then the book by Jonathan Gennick and Sanjay Sherma...
HTH,
- Kirti
-Original Message-
Sent: Wednesday, June 12, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L
We have an application that