Wednesday, February 10, 2010

Fact table

Fact table contains one or more fact column. Fact is what the business measures; for example, sales amount, sales quantity, duration of calls, number of calls (in telephone business), grade (school test result), rank (in sports for example)

In addition fact table has all the surrogate keys of its related dimensions.

No comments:

Post a Comment