Types of Dimensions

• Conformed Dim.: are the dimension which is shared between multiple facts 
• Parent – Child Dim : One dimension is derived from other 
• Role playing Dim. : Dimension are used for multiple application in same database 
• SCD : Dimension in which value change slowly in time 
• Time Dim : Dim which uses time as an changing factor 
• Rapid changing Dim: Which changes rapidly continuously 
• Junk Dim. :  is group of flags. The attributes in junk dimension do not belong to the fact table.  
• Degenerate Dim:  is a dimension which is derived from the fact table and doesn't have its own dimension table. (it do not have its own fact) 
• Small Dim.: Few no of records 
• Big Dim.: Duplicate records 
• Empty Dim.: It derived from a fact table and it does not have any dimension. 
• Mini Dimension: subset of large dimension