1.

What Are The Different Types Of Dimension?

Answer»

In a data warehouse model, dimension can be of FOLLOWING types,

  1. Conformed Dimension
  2. Junk Dimension
  3. Degenerated Dimension
  4. Role Playing Dimension

Based on how frequently the data inside a dimension CHANGES, we can further classify dimension as

  1. Unchanging or static dimension (UCD)
  2. SLOWLY changing dimension (SCD)
  3. Rapidly changing Dimension (RCD)

You may also read, Modeling for various slowly changing dimension and Implementing Rapidly changing dimension to know more about SCD, RCD dimensions ETC.

In a data warehouse model, dimension can be of following types,

Based on how frequently the data inside a dimension changes, we can further classify dimension as

You may also read, Modeling for various slowly changing dimension and Implementing Rapidly changing dimension to know more about SCD, RCD dimensions etc.


Discussion

No Comment Found

Related InterviewSolutions