Data flow - Process
CDC
(Change Data Capture)
Capturing data changes as they happen so other systems receive only what changed
What's it for?
Keeps another system up to date by sending only the information that has changed.
For example…
An orders database captures each new purchase as it lands and streams those changes into the data warehouse for near-live reporting.
CDC sends a customer address change from the operational database to the warehouse within seconds rather than waiting for the nightly load
Think of it like…
Texting someone each time a spreadsheet cell changes, instead of emailing the whole file every hour