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