• Home
  • Courses
  • Blog
  • Courses
    • Apache Spark
      • Course Introduction
      • Python Vs. Scala
      • Introduction
      • About Databricks
      • Spark In The Data Platforms
      • Running Spark
      • Demo: Running Spark on Linux Ubuntu
      • Demo: Running Spark on MacOS
      • Demo: Running Spark on Windows
      • Demo Running Spark On Databricks
      • From Map Reduce To Spark
      • Spark Characteristics
      • Spark Applications
      • Spark Driver
      • Spark Session
      • Spark Cluster Manager
      • Spark Execution Mode
      • Spark Executors
      • Spark Data Partitioning
      • Spark Operations
      • Transformations Narrow Vs Wide
      • Demo: Immutability In Spark
      • Demo: RDD Text Manipulation
      • Demo: GroupByKey Vs. ReduceByKey
      • Demo: Joining RDDs
      • Demo: RDD Operations Part 1
      • Demo: Repartition Vs. Coalesce
    • Data Modeling
      • Introduction to Data Modeling
      • Fact Tables
      • Schema Types
      • Surrogate vs Natural Keys
      • Partitioning vs Bucketing
      • Kimball vs Inmon
      • Dimension Types
        • Conformed Dimension
        • Degenerated Dimension
        • Junk Dimension
        • Role Playing
        • Outrigger Dimension
        • Snowflake Dimension
        • Slowly Changing Dimension
        • Fast Changing Dimension
        • Shrunken Changing Dimension
        • Multi Valued Dimension
        • Swappable Dimension
        • Heterogeneous Dimension
    • Containerization
      • Short-lived containers
      • Long-lived containers
      • More than 1 container app
    • Big Data Engineering in Depth
      • Course Introduction
        • Introduction
        • Max Benefit
        • Assignments, Labs, & Textbooks
        • Course Content Overview
      • Data Warehouse
        • Introduction To Data Management
        • Data Abstraction
          • Introduction
          • Physical Layer
          • Logical Layer
          • View Layer
          • Data Solution Thinking
        • Data Warehouse Components
          • Topics
          • Previous Chapters
          • Motivation
          • DWH VS Transactional DB
          • Business Types
          • Use cases
          • Multi-temperature Storage
          • Characteristics & Components
          • Source System Integration Process
          • Source System Extraction
          • Staging Layer
          • Data Modeling
          • Introduction to Data Modeling
          • ETL
          • Fact Tables
          • Schema Types
          • Dimension Types
            • Conformed Dimension
            • Degenerated Dimension
            • Junk Dimension
            • Role Playing
            • Outrigger Dimension
            • Snowflake Dimension
            • Slowly Changing Dimension
            • Fast Changing Dimension
            • Shrunken Changing Dimension
            • Multi Valued Dimension
            • Swappable Dimension
            • Heterogeneous Dimension
    • Hadoop and Distributed Systems
      • Introduction To Distributed Systems
      • Hadoop
      • HDFS
      • YARN
      • Map Reduce
      • Hive
  • Blog
  • Still need help?
  • Join Discord ↗
  • Apache Spark
    • Course Introduction
    • Python Vs. Scala
    • Introduction
    • About Databricks
    • Spark In The Data Platforms
    • Running Spark
    • Demo: Running Spark on Linux Ubuntu
    • Demo: Running Spark on MacOS
    • Demo: Running Spark on Windows
    • Demo Running Spark On Databricks
    • From Map Reduce To Spark
    • Spark Characteristics
    • Spark Applications
    • Spark Driver
    • Spark Session
    • Spark Cluster Manager
    • Spark Execution Mode
    • Spark Executors
    • Spark Data Partitioning
    • Spark Operations
    • Transformations Narrow Vs Wide
    • Demo: Immutability In Spark
    • Demo: RDD Text Manipulation
    • Demo: GroupByKey Vs. ReduceByKey
    • Demo: Joining RDDs
    • Demo: RDD Operations Part 1
    • Demo: Repartition Vs. Coalesce
  • Data Modeling
    • Introduction to Data Modeling
    • Fact Tables
    • Schema Types
    • Surrogate vs Natural Keys
    • Partitioning vs Bucketing
    • Kimball vs Inmon
    • Dimension Types
      • Conformed Dimension
      • Degenerated Dimension
      • Junk Dimension
      • Role Playing
      • Outrigger Dimension
      • Snowflake Dimension
      • Slowly Changing Dimension
      • Fast Changing Dimension
      • Shrunken Changing Dimension
      • Multi Valued Dimension
      • Swappable Dimension
      • Heterogeneous Dimension
  • Containerization
    • Short-lived containers
    • Long-lived containers
    • More than 1 container app
  • Big Data Engineering in Depth
    • Course Introduction
      • Introduction
      • Max Benefit
      • Assignments, Labs, & Textbooks
      • Course Content Overview
    • Data Warehouse
      • Introduction To Data Management
      • Data Abstraction
        • Introduction
        • Physical Layer
        • Logical Layer
        • View Layer
        • Data Solution Thinking
      • Data Warehouse Components
        • Motivation
        • DWH VS Transactional DB
        • Business Types
        • Use cases
        • Multi-temperature Storage
        • Characteristics & Components
        • Source System Integration Process
        • Source System Extraction
        • Staging Layer
        • Data Modeling
        • Introduction to Data Modeling
        • ETL
        • Fact Tables
        • Schema Types
        • Dimension Types
          • Conformed Dimension
          • Degenerated Dimension
          • Junk Dimension
          • Role Playing
          • Outrigger Dimension
          • Snowflake Dimension
          • Slowly Changing Dimension
          • Fast Changing Dimension
          • Shrunken Changing Dimension
          • Multi Valued Dimension
          • Swappable Dimension
          • Heterogeneous Dimension
  • Hadoop and Distributed Systems
    • Introduction To Distributed Systems
    • Hadoop
    • HDFS
    • YARN
    • Map Reduce
    • Hive
  • Still need help?
  • Join Discord ↗

On this page

  • Topics
  • Previous Chapters
Edit this page
Backlinks
  • Big Data Engineering in Depth
  • Dimension Types
Courses
Big Data Engineering in Depth
Data Warehouse
Data Warehouse Components

Data Warehouse Components

Topics

  1. Motivation
  2. DWH vs Transaction DB
  3. Business Types
  4. Use cases for DWH and Transactional DB
  5. Multi-Temperature Storage
  6. Characteristics And Components
  7. Source System Integration
  8. Source System Extraction
  9. Staging Layer
  10. Data Modeling
  11. Data Integration and ETL

Previous Chapters

Overview | Ch.01: Intro

Last updated on Jan 7, 2020

© 2024 Garage Education. This work is licensed under CC BY NC ND 4.0

Published with Hugo Blox Builder — the free, open source website builder that empowers creators.