Conformed dimension

by Amol 19. February 2011 11:07

Conformed dimension:

Dimensions are conformed when they are either exactly the same including keys. Perfect example of conformed dimension is "Date Dimension". The date dimension attached to sales facts is identical to date dimension attached to inventory facts.


Tags: ,


Types of Data Warehouse Dimension

by Amol 18. February 2011 08:51

In a data warehouse, dimension is one of the perspectives that can be used to analyze the data in an OLAP cube.
When you are browsing the data in a cube, you can view the data from the perspective of different combinations of dimensions.

With dimension, data can be slice and dice to analyse it in different prospective. Dimensions are used to provide structured lebeling information to measures. Another use of dimension other than lebeling is to provide filtering, grouping.

For example, for a Sales database, the dimensions could include Product, Time, Store, and Promotion.

Each dimension may have one or more hierarchies applied to it. For the "Date" dimension, there are several possible hierarchies: "Day > Month > Year", "Day > Week > Year", "Day > Month > Quarter > Year", etc.

Types of dimension :

  1. Conformed dimension
  2. Junk dimension
  3. Degenerate dimension
  4. Role-playing dimensions


Tags: , , ,

Data Warehouse

Tag cloud