Message-Id: <10700.123617@fatcity.com> From: jared still Date: Mon, 4 Dec 2000 20:45:25 -0800 (PST) Subject: Re: DW data modeling question On Mon, 4 Dec 2000, [iso-8859-1] paquette stephane wrote: > 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 Um, what's that point? The purpose of a fact table is to slice and dice, otherwise put it in a dimension. > 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 ! That probably needs pursuing, as it seems an unlikely scenario.