Question
What does Change Data Capture provide to an ETL process?
Select an option. Your answer will be checked instantly.
Correct Answer: B. A record of source inserts, updates, and deletes that occurred after a point in time
Explanation:
CDC exposes data changes so the warehouse can load them incrementally.
It is more precise than repeatedly scanning the entire source table.
Leave a Reply