Data Warehouse & ETL Interview Questions: CDC Replay and Backfill Correctness
Fourteen interview questions on change data capture, incremental loads, deletes, replay, and backfills—with runnable examples and production-grade reasoning.
16 min
Search
3 results for “etl”
Fourteen interview questions on change data capture, incremental loads, deletes, replay, and backfills—with runnable examples and production-grade reasoning.
A practical interview guide to modeling dimensional history, handling late-arriving changes, and keeping facts correctly attributed across time.
Q17 — Window Functions — ROW_NUMBER, LAG, SUM OVER, Running Totals Level: Mid-Level | Topic: SQL Server What Are Window Functions? Window functions operate across a set of rows without collapsing them into a single outpu...