Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Load and Query question

Re: Load and Query question

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Sat, 29 Apr 2006 22:56:04 +0200
Message-ID: <00b201c66bcf$554d7620$3c02a8c0@JARAWIN>


Mladen,

> In data warehouse situation, you don't have to prevent data from entering,
> data is
> already checked and trusted, you are extracting data from your OLTP
> database, ..

I'd love to operate a DW above your OLTP. In my experience I sow a lot of systems where the data is only trusted.

> You must index your DW properly. Indexing schemes are widely described
> in various books.

paradoxically from the point of view of loading data in DW with full refresh (as discussed in this thread) the best indexing schema is the empty one as

etc.

Of course those that are performing query of the data in DW see this a little different:)

Regards,

Jaromir

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 29 2006 - 15:56:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US