or go to full-text search page →
Second Brain
Blogs
Brain
DE Vault
Book
About

Search

Search IconIcon to open search

Dimensions

Last updatedUpdated: by Simon Späti · CreatedCreated: · 1 min read recently updated Recent changes 4 months ago +33 / −0 words 6 months ago +0 / −3 words 2 years ago published · 0 words

A dimension is a structure that categorizes and describes data in a business process to enable easy access and analysis in Dimensional Modeling.

Dimensions are essentially the descriptive attributes associated with the data, such as time, location, or product details. Dimensions are linked from Fact Table through Foreign Keys.

# The 4 Common Types of Dimensions
  1. Role-Playing Dimensions
  2. Conformed dimensions
  3. JunkDimension
  4. Degenerate dimension

Listen the video form Michael Kahan at The 4 Common Types of Dimensions.

Origin:

Data Engineering & Second Brain Newsletter

This note is part of my Second Brain, a 650+ public notes on data engineering, life, and more. I send a digest of new notes, blog posts, and book chapters, and general updates by email. Subscribe below if you'd like to get the next one.

Interactive Graph

Backlinks