Articles: Architecture/Modeling: Advanced Fact Table Topics
Wrangling Behavior Tags (5/9/2002)
Behavior tags are true "text facts."
How do we handle them in a data warehouse?

Realtime Partitions (2/1/2002)
Build a special extension of each fact table to complement
your static data warehouse

Managing Your Parents (9/18/2001)
Parent-child source databases are modeled in a consistent way
in a dimensional data warehouse

Fundamental Grains (3/30/1999)
Three basic fact table types: transaction, periodic snapshot,
accumulating snapshot

What Didn't Happen (2/16/1999)
How to ask your data warehouse for records that may not be there

Factless Fact Tables ((9/1996)
Two types of useful fact tables contain no facts at all