conventions modelling summary data in a datawarehouse
From: Rick Ricky <ricks12345_at_gmail.com>
Date: Wed, 14 May 2008 11:46:51 -0400
Message-ID: <81f4c0700805140846r506182f2s946f2a305da515b8@mail.gmail.com>
Date: Wed, 14 May 2008 11:46:51 -0400
Message-ID: <81f4c0700805140846r506182f2s946f2a305da515b8@mail.gmail.com>
I don't do a lot of data warehousing. We have a variety of summary tables
that are daily and monthly rollups of our Fact tables. This is not
primary/foreign key relationship. Is there some sort of standard line or
convention you use to show a relationship from a Fact table to a summary
table in a model? I want to make the model easy to read for people.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 14 2008 - 10:46:51 CDT