Insert each new CDC record and its corresponding operation type in real-time to a staging table

Use DML MERGE periodically to perform several DML INSERT, UPDATE, and DELETE operations at the same time on the reporting table.

Replicate each individual CDC record in real-time using DML INSERT, UPDATE, or DELETE operations directly on the reporting table

Periodically delete outdated records from the reporting table.

Insert each new CDC record and its corresponding operation type in real-time to the reporting table, and use a materialized view to expose only the latest version of each unique record