# Dimensional Data Modeling - Slowly-changing Dimensions and Idempotent Queries in Iceberg (Day 2 Lecture) - Pre-recorded from V3

> This is a pre-recorded lesson from V3. In this presentation, we delve into the concept of idempotent pipelines, exploring their significance, advantages, and potential drawbacks. We provide insights into Slowly Changing Dimensions (SCDs) and discuss the various types. Discover whether SCDs are inhe…

- Web page: https://www.dataexpert.io/lesson/dimensional-data-modeling-day-2-lecture-v4
- Program: [Data Engineering Mastery Course](https://www.dataexpert.io/program/data-engineering-mastery-course)
- Module: Week 1: Dimensional Data Modeling in Iceberg
- Access: Requires enrollment in Data Engineering Mastery Course
- Length: 47 min video
- Skills: Data Modeling, ETL/ELT, Apache Iceberg
- Academy: DataExpert.io Academy

## About this lesson

This is a pre-recorded lesson from V3. In this presentation, we delve into the concept of idempotent pipelines, exploring their significance, advantages, and potential drawbacks. We provide insights into Slowly Changing Dimensions (SCDs) and discuss the various types. Discover whether SCDs are inherently idempotent or not and grasp the implications of their usage in data pipelines. Join us to gain a clear understanding of these foundational concepts in data processing. [Recorded Nov 8, 2023]

## Navigation

- Previous lesson: [Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lab) - Pre-recorded from V3](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-1-lab-v4.md)
- Next lesson: [Dimensional Data Modeling - Slowly-changing Dimensions and idempotent queries with Trino (Day 2 Lab) - Pre-recorded from V3](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-2-lab-v4.md)