Types of Dimension Tables

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 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.

One thought on “Types of Dimension Tables

Leave a Reply

Your email address will not be published. Required fields are marked *