conventions modelling summary data in a datawarehouse
Date: Wed, 14 May 2008 11:46:51 -0400
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.