GLOSSARY

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.