Conformed Dimension

Ch.02: DWH | DWH Components | Data Modeling | Dimension Types

Lesson Notes

Conformed Dimension Lesson Notes

Video

Conformed Dimensions

Conformed Dimensions: the dimension which is and has the across many fact tables which it relates and used in different areas of the warehouse.

  • Date as a Key: if we have a date column across many facts, we could use the date as key in all tables. So, it should be a unified format.

  • Product-Id as a Key: if we have a product name which could vary between systems ex: (upper/lower) We can create a dimension table for the product details and use product id unified across fact tables.

Further Reading

  • Chapter 5: Dimensional Model Design Life Cycle Section 5.4.3 from Dimensional Modeling: In a Business Intelligence Environment. The book is free, and you can download it from this link.

Previous Chapters

Overview | Ch.01: Intro