hard20 pts · first answer countsdata-pipelineschange-data-captureidempotency
An older update overwrites a newer one
After a replay, a MERGE applied an older CDC update after a newer one, and the target now shows a stale price. How should the MERGE guard against this?
Discussion 0
Join free to post in the discussion.
Related questions
- ETL vs ELTData Engineer
- Idempotent pipelinesData Engineer
- Batch or streaming for a daily reportData Engineer
- Incremental logic for a tiny tableData Engineer
- What SCD Type 1 doesData Engineer
- Keeping the old customer segmentData Engineer
- Why a dimension has its own keyData Engineer
- The bronze layerData Engineer