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>


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-l
Received on Wed May 14 2008 - 10:46:51 CDT

Original text of this message