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

Types of Dimensions

Date Dimension Tablechevron-rightDegenerate Dimensionchevron-rightJunk Dimensionchevron-rightStatic Dimensionchevron-rightConformed Dimensionschevron-rightSlowly Changing Dimensionschevron-rightRole Playing Dimensionchevron-rightConformed vs Role Playingchevron-rightShrunken Dimensionchevron-rightSwappable Dimensionchevron-rightStep Dimensionchevron-right
PreviousSteps of Dimensional Modelingchevron-leftNextDate Dimension Tablechevron-right

Last updated 2 years ago