Loading...
CDC Connector: Log-Based vs Trigger-Based
A medium Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant grading.
- Domain
- Pipeline Design
- Difficulty
- medium
- Seniority
- senior
Problem
Our data team needs to replicate changes from several production databases into the warehouse in near-real time. We've been debating two approaches: reading directly from the database write-ahead log, or using database triggers to capture changes. Design a CDC replication system and make a concrete recommendation for which capture method to use across our source databases.
Practice This Problem
Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and grades it instantly.