PowerExchange queries each registered table to determine if the insert, update, and delete triggers exist. If a trigger does not exist for a table, PowerExchange creates it.

Alternatively, you can create the triggers in the tables registered for change data capture manually. You can use the PowerExchange Navigator to create DDL that inlcudes the triggers. If you choose to create the triggers manually, make sure you grant permissions to the user ID connected to the source database as described in Granting Additional Permissions.

If a table is removed from the list of registered tables, PowerExchange removes the trigger that it automatically created from that table. You can list the triggers to verify that PowerExchange removed the triggers from the removed source table. You can list the triggers by using the following command:

SELECT * FROM TRIGGERS WHERE SCHEMA_NAME = '<
schema_name>

If you enable or disable the Full Audit option for a registered table, you must drop and recreate the triggers for that table. You can manually create the triggers or allow the PowerExchange Logger to create them automatically. Optionally, you can also drop and recreate the CDC table.