For Audit and Merge Apply modes used for target types other than
Apache Kafka,
Cloudera,
Flat File,
and
Hortonworks
, a table on the target system that you can use to audit change activity. The table contains a row for each committed DML operation on the source, and _OLD and _NEW columns that contain the before and after values for each mapped source column, as appropriate for the operation type. Also, each row includes metadata about the DML operation such as the timestamp, SCN or LSN, and transaction ID. By default, the name of the audit log table matches the name of the corresponding source table followed by the _LOG suffix.