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. Received on Mon Dec 04 2000 - 22:45:25 CST