Replicat maintains its checkpoints in a checkpoint table in the Teradata target database (the database where you use DBLOGIN). Each checkpoint is written to the checkpoint table within the Replicat transaction. Because a checkpoint either succeeds or fails with the transaction, Replicat ensures that a transaction is only applied once, even if there is a failure of the process or the database.

Use the following GGSCI command on the target system, to create the Replicat checkpoint table.

ggsci> ADD CHECKPOINTTABLE schema.chkptabl Successfully created checkpoint table schema.chkptabl

For more information about creating a checkpoint table, see Administering Oracle GoldenGate.