fact, dimenssion tables

Posted by Sudheep.grandhe under Sql Server on 5/5/2011 | Points: 10 | Views : 1155 | Status : [Member] | Replies : 1
Hi briefly explain about fact and dimenssion tables in datawarehouse



Posted by: Nishithraj on: 5/5/2011 [Member] Bronze | Points: 25

Facts are the metrics that business users would use for making business decisions. Generally, facts are mere numbers. The facts cannot be used without their dimensions. Dimensions are those attributes that qualify facts. They give structure to the facts. Dimensions give different views of the facts.

Attached screen is an example, here screen represents an example of a simple star schema with a single fact table(Daily Sales) and 5 dimension tables.

 Download source file

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response