What is a CDC log?
💡 Model Answer
A CDC log, or change data capture log, is a record of all changes (inserts, updates, deletes) that occur in a database table or set of tables. It captures the before and after values of each row, along with a timestamp and transaction ID. CDC logs enable downstream systems to consume only the changes rather than re‑reading entire tables, which improves performance and reduces latency. Common CDC implementations include database transaction logs (e.g., Oracle redo logs, SQL Server transaction logs), binlog in MySQL, or change streams in NoSQL databases. By reading the CDC log, an ETL pipeline can apply incremental updates to a data warehouse or trigger downstream processes.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500