Re: Loading 300 million records

From: Anurag Varma <avoracle_at_gmail.com>
Date: 6 Jun 2005 14:06:46 -0700
Message-ID: <1118092006.577837.216690@g43g2000cwa.googlegroups.com>

Daniel,

Not knowing OP's overall process and considering that OP is doing a insert /*+ append */ into maintable select ... from <join of 5 tables>;

... the idea of selecting from ext_tab and etl transforming does not really compute.

Although, tuning his sql (maybe use parallel processing etc.) might speed things up
for him.

The paper as such is ok. It does have some nice ideas about etl processing
(especially the example you state above).

Cheers,

Anurag Received on Mon Jun 06 2005 - 16:06:46 CDT