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

Home -> Community -> Usenet -> c.d.o.server -> Data Warehouse question

Data Warehouse question

From: <michael_bialik_at_my-deja.com>
Date: Sun, 01 Aug 1999 21:01:10 GMT
Message-ID: <7o2cii$cvp$1@nnrp1.deja.com> 





Hi,



 What is the better way :


    
  
  1.   To keep a "fact" table and a number of "dimension"
     tables separate ( perform a star join for each
     query ), or
  
  2.   Denormalize the tables and avoid the joins.






  Fact table - 3M - 4M rows.


  Dimension tables - 20 - 30K rows max.



 Thanx. Michael.





Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Sun Aug 01 1999 - 16:01:10 CDT












Original text of this message













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