Data Warehousing
Ctrlk
  • Data Warehousing
  • Readme
  • Fundamentals
    • Terms to Know
    • Jobs
    • Skills needed for DW developer
    • Application Tiers
    • Operational Database
    • What is a Data Warehouse
    • Activities of Data Science
    • Types of Data
    • Data Storage Systems
    • Data Warehouse 1980 - Current
    • Data Warehouse vs Data Mart
    • Data Warehouse Architecture
    • Data Warehouse Characteristic
    • Tools
    • Cloud vs On-Premise
    • Steps to design a Data Warehouse
    • Dataset Examples
    • Thoughts on some data
  • RDBMS
    • Data Model
    • Online vs Batch
    • DSL vs GPL
    • Connect to Elvis
    • SQL Concepts
    • Practice using SQLBolt
  • Cloud
    • Overview
    • Types of Cloud Services
    • Challenges of Cloud Computing
    • AWS
    • Terraform
  • Spark - Databricks
    • Storage Formats
    • File Formats
    • Medallion Architecture
    • Delta
  • Data Warehousing Concepts
    • Dimensional Modelling
    • Dimension - Fact
    • Sample Excercise
    • Keys
    • More Examples
    • Master Data Management
    • Steps of Dimensional Modeling
    • Types of Dimensions
      • Date Dimension Table
      • Degenerate Dimension
      • Junk Dimension
      • Static Dimension
      • Conformed Dimensions
      • Slowly Changing Dimensions
      • Role Playing Dimension
      • Conformed vs Role Playing
      • Shrunken Dimension
      • Swappable Dimension
      • Step Dimension
    • Types of Facts
    • Sample Data Architecture Diagram
    • Data Pipeline Models
    • New DW Concepts
Powered by GitBook
On this page
  1. Data Warehousing Concepts

Types of Dimensions

Date Dimension TableDegenerate DimensionJunk DimensionStatic DimensionConformed DimensionsSlowly Changing DimensionsRole Playing DimensionConformed vs Role PlayingShrunken DimensionSwappable DimensionStep Dimension
PreviousSteps of Dimensional ModelingNextDate Dimension Table

Last updated 1 year ago