Re: Star Schema -Datawarehousing

From: BP Margolin <bpmargo_at_attglobal.net>
Date: 2000/09/20
Message-ID: <eCdmsS2IAHA.88_at_cppssbbsa02.microsoft.com>#1/1


Joe,

You might consider posting this to the microsoft.public.sqlserver.olap and/or .datawarehousing newsgroups.



BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which can be cut and pasted into Query Analyzer is appreciated.

"Joe Bala" <jcsbalas_at_undergrad.math.uwaterloo.ca> wrote in message news:8qbjg9$1d7$1_at_nnrp1.deja.com...
> Hi,
>
> We're trying to design a star schema with a fact table and
> dimensions. We have employee fact table and we have a list of the the
> employees interests. If we include interests as a dimension we have
> two many combinations (there are 8 interests and therfore 2^8
> combinations of interests). So another idea was to include the
> interests as part of the fact table (measures).. but I don't think it's
> a good idea to hardcode interests in the fact table.
>
> thx,
>
> j
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 20 2000 - 00:00:00 CEST

Original text of this message