Apply Checkpoint – The last LSN identifier for any data change applied.
Apply Process – Is the “Process” that inserts the extracted Data into the specified Target Database.
Capture Checkpoint – The last LSN identifier for any data change captured.
Capture Process – Is the “Process” that extracts Data from the specified Source Database.
DDL – Type of the Database Statement, that is used to provide or modify a Dictionary Definition of a database object.
DML – Type of the Database Statement, that is used to modify Data in the tables.
LSN – Every record in Trail Files is identified by a Log Sequence Number generated by SQL Server CDC functionality.
Process – This can be either Capture or Apply Process.
SCN – every record in the Trail Files is identified by a System Change Number generated by Oracle.
Source Database – Is the Database from which you wish to extract/copy Data.
Target Database – Is the Database into which you wish to insert/copy Data.
Trail Files – These are the “Source Files” – containing Data extracted by a Capture Process and used by an Apply Process.
Transformation Rules – these are the rules provided by user to change/control transactions processing behavior.