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

> 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…

- Web page: https://www.dataexpert.io/lesson/dimensional-data-modeling-day-2-lecture-v3
- Program: [Data Engineering Boot Camp V2 Combined Track](https://www.dataexpert.io/program/data-engineering-boot-camp-v2-combined-track)
- Module: Week 1: Dimensional Data Modeling in Iceberg
- Access: Requires enrollment in Data Engineering Boot Camp V2 Combined Track
- Length: 53 min video
- Skills: Data Modeling, ETL/ELT, Apache Iceberg
- Academy: DataExpert.io Academy

## About this lesson

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 - Slowly-changing Dimensions and idempotent queries with Trino (Day 2 Lab)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-2-lab-v3.md)
- Next lesson: [Dimensional Data Modeling - Graph Data Modeling with Iceberg (Day 3 Lab)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-3-lab-v3.md)