hard20 pts · first answer countscdcincremental-loads

Applying CDC events

You apply Debezium CDC events to a warehouse table in micro-batches. A batch contains an insert, two updates and a delete for the same primary key. What is the correct way to apply it?

A.Apply all events in random order since they are in the same batchB.Ignore deletes because warehouses cannot deleteC.Keep only the latest event per key by log position (such as LSN), then MERGE: delete if it is a delete, otherwise upsertD.Insert all four rows and deduplicate in every downstream query

Discussion 0

Join free to post in the discussion.

Applying CDC events

Discussion 0

Related questions