Types Of Measure And Types Of Fact Tables

Transaction Fact Tables:
Every record represents one transaction; such as the sales of an item in a store.

Periodic Snapshot Fact Tables: 
Every record represents a measure for a period of time.

Accumulating Snapshot Fact Tables:
Each fact represents a process, business process, with a clear beginning and end.