Re: Joining fact tables?

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: Mon, 25 Oct 1999 16:00:47 +0100
Message-ID: <3814709F.27AEC23D@totalise.co.uk>

<snip>
> > It is a good thing to combine multiple fact tables. Indeed it is a
> > requirement.
>
> Hm. Most people seem to warn against this. From what I know, the
> thinking is that "one fact table per datamart". If you are joining 2
> fact tables, you are combining apples and oranges (different subject
> areas) i.e. your initial design was flawed.
>
> Would you care to share any examples/design criteria to back up this
> assertion that joining fact tables is "good".
>

Hi
Check out Ralf Kimballs book "The Data Warehouse Lifecycle Toolkit" for a full explanation.

martin Received on Mon Oct 25 1999 - 10:00:47 CDT