Thursday, 6 March 2014

Fact Table

Fact Table

The Fact table contains numerical values of what we measure.It is a measurement of a business process.
Characteristics of Fact table:-
1. Fact table contains the keys to associated dimension tables which are foreign keys in fact table.
2. Fact table has lesser number of columns than Dimension table and larger number of rows   than Dimension table

3. Fact table consist numerical attributes and used for calculation like- sum, aggregate etc.

No comments:

Post a Comment