DW data modeling question

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Mon, 4 Dec 2000 05:40:30 -0800 (PST)
Message-Id: <10700.123518@fatcity.com>

Hi,

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.

TIA

---

Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

---

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. Received on Mon Dec 04 2000 - 07:40:30 CST