Optionally, the PowerExchange Navigator can generate scripts for creating the PKLOG and PROCESSED log tables, the CDC tables for Full Audit, and the trigger DDL when you register the source tables. If you do not use the Navigator scripts to create the log tables and triggers, PowerExchange creates them when the extraction process runs.

The triggers write inserts, updates, and deletes to the PKLOG transaction log table and the CDC table. The changes are read in table order and then become available for extraction to PowerCenter CDC sessions or PowerExchange CDC Publisher.