chandu
Answered On : 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.
Login to rate this answer.
Joe
Answered On : Aug 21st, 2012
1. Conformed Dimensions
2. Junk Dimensions
Login to rate this answer.