Explain how you performed CDC from Oracle using DMS. Provide an example with a specific table.

To perform CDC from Oracle using AWS DMS, you first enable the Oracle redo logs and set up a source endpoint pointing to the Oracle database. Then create a target endpoint (e.g., Amazon RDS or Aurora). In the DMS task settings, choose CDC mode, specify the tables to migrate, and configure the task to capture changes from the redo logs. Use the 'Full load + CDC' option so that the initial load is performed and subsequent changes are streamed. Example: Suppose you have a table EMPLOYEES with columns ID, NAME, SALARY. You create a DMS task that loads the entire table initially, then continuously reads the redo logs to capture INSERT, UPDATE, DELETE operations on EMPLOYEES. The task writes these changes to the target database, keeping it in sync. You monitor the task via the DMS console, check the replication instance, and adjust the task settings if needed. This approach ensures minimal downtime and real‑time data synchronization.