Types of Dimension Tables in a Data Warehouse

Photo by Andrea Piacquadio from Pexels

Major Types of Dimensions in a Data Warehouse

  1. Slowly Changing Dimension
  2. Conformed Dimension
  3. Degenerate Dimension
  4. Junk Dimension
  5. Role-playing Dimension
  6. Static Dimension
  7. Shrunken Dimension

1. Slowly Changing Dimension

Photo by Alexas Fotos from Pexels

2. Conformed Dimension

Photo by Tim Mossholder from Pexels

3. Degenerate Dimension

Photo by Obsahovka Obsahovka from Pexels
Photo by Pixabay from Pexels

5. Role Playing Dimension

Photo by Bich Tran from Pexels

6. Static Dimension

Photo by Magda Ehlers from Pexels

7. Shrunken Dimension

Photo by Lukas from Pexels

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Abhilash Marichi

Abhilash Marichi

Data Engineer at Amazon. I write about Data, Product & Life.