• 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
        • Lesson Notes
        • Video
      • 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
  • 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

  • Lesson Notes
  • Video
Edit this page
Backlinks
  • Data Modeling
Courses
Data Modeling
Surrogate vs Natural Keys

Surrogate vs Natural Keys

Lesson Notes

Surrogate vs Natural Keys Lesson Notes:

  1. Presentation Mode

Video

Last updated on Jan 7, 2020
← Schema Types
Partitioning vs Bucketing →

© 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.