Here in this section, I am going to give a very brief explanation about few regular terms. Later I will cover Star schema and snow flake schema and slowly changing dimensions as well.
Dimension:
Dimensions provide the "Who When What Why How " context in the surroundings of a business process event.
Fact:
Facts are the measurements that result from a business process event and facts are almost always numeric.
Dimension table:
Dimension table stores attributes or dimensions that describe the objects in the fact table.
Fact Table:
Fact table contains the numeric measures produced by an operational measurement event in the real world.
No comments:
Post a Comment