NOCOMPRESSUPDATES parameters for Extract to control the way columns are written to the trail record for
COMPRESSUPDATES, the default, causes Extract to write only the primary key and the changed columns of a row to the trail for update operations. This provides enough information to update the correct target record (unless conflict resolution is required), while restricting the amount of data that must be processed.
If other columns are supplementally logged by the database for use by Oracle GoldenGate, Extract writes those columns to the trail as well. Additionally, if a substitute key is defined with the
KEYCOLS option of the
TABLE parameter, those columns are written to the trail, whether or not a primary or unique key is defined. See "
)" for more information.
NOCOMPRESSUPDATES sends all of the columns to the trail. This becomes the default when a table definition does not include a primary key or unique index.
NOCOMPRESSUPDATES also is required when using the Conflict Detection and Resolution (CDR) feature for a DB2 database on any of the platforms that are supported by Oracle GoldenGate. See Administering Oracle GoldenGate for Windows and UNIX for more information about CDR.
NOCOMPRESSUPDATES apply globally for all
TABLE statements in a parameter file.
These parameters support the following databases:
Teradata version 12 or later
NOCOMPRESSUPDATES do not affect data pumps.