Monday, November 28, 2011

What is SQL Server Analysis Service: Chapter 2 (Fact and Dimension?)

What is SQL Server Analysis Service: Chapter 2 (Fact and Dimension?)
OLAP data warehouse works across the facts and dimension tables. These are the two parts of representation of data warehouse.
FACT: Fact table is the table which calculates the data which can be measured i.e. calculated i.e. the numeric values.


Dimensions: Dimension is the attributes for which we measure or calculates the numeric value.
Example of Fact and Dimension:
Suppose we have retail shop which sales different product. In this case the price of the product and quantity are the numeric value which can be calculated these values will refer as Fact. The attributes like product, costumers will be referred as the dimensions. As we can measure the information corresponding to the customer or product.
Conclusion
Fact are the numeric data i.e. data which can be measured.
Dimension are the attributes corresponding to which we can measure some thing.

1 comment:

  1. Microsoft SQL Server 2012 RC0 has recently released. RC stands


    Interview Questions

    ReplyDelete