5.2 — Orchestration Jobs vs Transformation Jobs
crash
deep
This lesson is scaffolded. The full expanded version will be generated in your next tutor session — or you can jump in right now and we'll build it together.
Learning objectives
- When to use each, and why the boundary matters
- Shared Jobs for reusable orchestration patterns
- Variables, iterators, and conditional branching in orchestration
- How to design transformation graphs that compile to efficient SQL
How to use this page today
Three options:
- Skim the objectives above — they tell you what the full lesson will cover, so you can gauge if it's interview-critical for you right now.
- Read the linked docs for this topic in Credits.
- Open a tutor session on this course folder and ask to "generate Lesson 5.2" — the course scaffold persists everything, and the tutor will expand this page in place with worked examples and a mini-quiz.
Until then — capture what you already know
Use the 📓 notepad to brain-dump anything you know about this topic from prior work. That seeds the tutor session when you do it and keeps you thinking actively about where you're strong and where you're not.