goldengate 的 COMPRESSUPDATES 引數

msdnchina發表於2011-05-27

Valid for Extract
Use the COMPRESSUPDATES and NOCOMPRESSUPDATES parameters for Extract to control the way
columns are written to the trail record for update operations.
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, while restricting the amount of data that
must be processed.
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. If a substitute key was
defined for that table with the KEYCOLS option of the TABLE parameter, then those columns
are written to the trail, whether or not a real key was defined.
COMPRESSUPDATES and NOCOMPRESSUPDATES apply globally for all TABLE statements in a
parameter file.
This parameter supports only the following databases:
● DB2 LUW and DB2 z/OS
● Teradata version 12 or later
● SQL Server
● Sybase

COMPRESSUPDATES and NOCOMPRESSUPDATES do not affect data pumps.

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/161195/viewspace-1050432/,如需轉載,請註明出處,否則將追究法律責任。

相關文章