Tuesday, 8 January 2013

Explain the Types of Dimension Tables? | Data Stage

Conformed Dimension:  If a dimension table is connected to more than one  fact table,  the granularity that is defined in the dimension table is common across between  the fact tables.
Junk Dimension: The Dimension table, which contains only flags.
Monster Dimension: If rapidly changes in Dimension are known as Monster Dimension.
De-generative Dimension: It is line item-oriented fact table design. 

No comments: