chandu

• Sep 21st, 2011

 

There are 3 types of dimensions.type-1,type-2,type-3.

type-1:it maintains only latest information.

type-2:it maintains both previous and updated information.in this surrogate key comes into picture.most of the cases we use this type.

type-3:it maintains partial history of data.

Joe

• Aug 21st, 2012

 

1. Conformed Dimensions
2. Junk Dimensions

priyank_divya

 Profile Answers by priyank_divya 

• Aug 28th, 2013

 

Conformed Dimension: Used across lines of businesses to gather information from across LOBs. Eg. if we want to know the deptnames where the avg salary of employees is more than the overall avg.
Junk Dimension: These are not related to any dimensions. Eg. Flags(Y/N)
Degenerate Dimension: Dimension present in the fact table. Eg. Transaction No, Invoice No
Role Playing Dimension: Date Dimension, which can be treated in many ways.
SCD: Slowly Changing Dimensions(Type 1,2,3,4,6)