# Cumulative DAGs in Production Day 3 Lecture

> Cumulative DAGs are a complex yet powerful concept in data engineering, particularly when using Apache Airflow. This lecture explores the debate between functional and efficient data engineering, focusing on cumulative table design and its implications for slowly changing dimensions (SCDs). Partici…

- Web page: https://www.dataexpert.io/lesson/cumulative-dags-in-production-day-3-lecture-jan2025-p736-l760
- Program: [AnalyticsExpert](https://www.dataexpert.io/program/analytics-expert)
- Module: Week 6: Airflow & Pipeline Specs with Trino
- Access: Requires enrollment in AnalyticsExpert
- Length: 41 min video
- Skills: Data Modeling, ETL/ELT, Airflow, Data Warehousing
- Academy: DataExpert.io Academy

## About this lesson

Cumulative DAGs are a complex yet powerful concept in data engineering, particularly when using Apache Airflow. This lecture explores the debate between functional and efficient data engineering, focusing on cumulative table design and its implications for slowly changing dimensions (SCDs). Participants will learn about the trade-offs involved in maintaining simplicity versus efficiency in data pipelines, as well as techniques for effectively managing large datasets while minimizing duplication.

## Navigation

- Previous lesson: [Hard Orchestration Lessons Day 2 Lab](https://www.dataexpert.io/lesson/hard-orchestration-lessons-day-2-lab-jan2025-p736-l726.md)
- Next lesson: [Cumulative DAGs in Production Day 3 Lab](https://www.dataexpert.io/lesson/cumulative-dags-in-production-day-3-lab-jan2025-p736-l761.md)