Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Star Schema -Datawarehousing

Re: Star Schema -Datawarehousing

From: David Whitmore <c4david_at_flash.net>
Date: 2000/09/21
Message-ID: <39C97FD8.8235E6F7@flash.net>#1/1

Joe, try referencing the two tables by using an employee number as the foreign key in those tables.
David Whitmore

Joe Bala wrote:

> 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.

--
-----------------------------------------------------
Click here for Free Video!!
http://www.gohip.com/free_video/
Received on Thu Sep 21 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US