Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DW data modeling question

RE: DW data modeling question

From: Jeffery Stevenson <>
Date: Mon, 4 Dec 2000 08:47:59 -0600
Message-Id: <>

  Are they the same 4 boolean fields in the fact and aggregate tables (or are they different fields and all just happen to be boolean)? If they are the same, it could be possible that those fields are for implementing an application specific requirement (maybe a specific query tool requires them or some nonsense such as that). The only way to really know is to ask questions and find out exactly what they are being used for. As for your second part, not everything needs to be sliced and diced by time (I can see not having a time dimension as being an extremely rare thing, but still a possibility)...if they only need one timeframe like daily rollups of data and there is a guarantee not to have to further aggregation of the data by multiple time factors, then a time dimension might not be necessary (but implementing one in the dimensional model wouldn't hurt you either because it would be just as efficient and would allow further growth of the system in case they change their minds).

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
From: paquette stephane [] Sent: Monday, December 04, 2000 7:40 AM
To: Multiple recipients of list ORACLE-L Subject: DW data modeling question


I'm new to the project but here are 2 things that bothered me :

  1. The dev team is putting 4 boolean fields in the fact and the aggregate tables. I've check in Tha Data Warehouse Toolkit by Ralph Kimball and did not found any examples of this. I guess that we could put those boolean in a mini-dimension.
  2. There is no time dimension !

Any comment ?

In a previous DW project, we had 3 time dimensions and no boolean in the fact tables and the DW was a big success.


Stephane Paquette
DBA Oracle

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.

Please see the official ORACLE-L FAQ:

Author: =?iso-8859-1?q?paquette=20stephane?=   INET:
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Mon Dec 04 2000 - 08:47:59 CST

Original text of this message