New to Data Warehousing..need basic info of Dimension and fact table--very basic level information with some examples
There is msdn for developers who want to start with a perticular Microsoft technology.
Check this link for the basics of data warehousing inclusing dimensions,facts etc.
To give you a brief idea, I willtry to explain with a simle example.
Suppose you have sales data of some company, and now you want to analyze it.
Dimension: This is nothing but how you want to view/query your data. For example, you may want to see your sales based on countries/products/customers/employees etc. So these four tables work as dimensions.
Facts: Fact tables are the tables where the data to be aggregated lies(sales values in our case). ================================
Plaese mark as answer if helpful.
You may find this lesson helpful, as well as some of the related ones in the same section and in the SSAS sections:
Rob Kerr SQL Server MVP CTO, BlueGranite
- Proposed as answer by Jerry NeeModerator Tuesday, April 24, 2012 10:03 AM
I think the above links would definitely help. Let me give you a short example.
Lets take the sales of a particular company, It has different
3) Departments for these sales
Suppose you need the sales of this company for a particular Product and a particular geography. The Sales data is the fact data and the product and Geography are your dimensions based on which you are measuring your sales.
Dimensions in my above examples are DimProduct and Dimgeography and DimDepartment.
FactSales is the table which has all the factual data + a forgiegn key relationship to the Dimensions.