goldengate 的 COMPRESSUPDATES 引數
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- goldengate的HANDLECOLLISIONS引數Go
- goldengate的ASSUMETARGETDEFS引數Go
- GOLDENGATE常用引數Go
- HANDLECOLLISIONS :GoldenGate Replicat的引數Go
- 瞭解GoldenGate Replicat的HANDLECOLLISIONS引數Go
- GoldenGate 基本引數含義Go
- oracle goldengate引數學習OracleGo
- Oracle GoldenGate常用引數詳解OracleGo
- GoldenGate HANDLECOLLISIONS引數使用說明Go
- goldengate OGG引數規範Go
- goldengate 引數之GETTRUNCATES | IGNORETRUNCATESGo
- Goldengate引數簡要說明Go
- GoldenGate的一些引數的意義Go
- GoldenGate學習筆記(11)_常用引數Go筆記
- goldengate關於CONVERTUCS2CLOBS引數Go
- GoldenGate 配置文件,裡面有引數說明Go
- goldengate 目的端程式引數APPLYNOOPUPDATES 和ALLOWNOOPUPDATESGoAPPOOP
- goldengate 中使用batchsql引數需要額外考慮的地方GoBATSQL
- 關於Oracle GoldenGate 引數TRANLOGOPTIONS altarchivelogdestOracleGoHive
- oracle goldengate 複製端延時應用引數OracleGo
- Oracle GoldenGate系統之----相關引數說明OracleGo
- 使用隱含引數testMappingSpeed排查GoldenGate抽取慢的步驟APPGo
- oracle goldengate 雙活複製避免迴圈複製引數OracleGo
- 【原創】一對雙引號引發的goldengate血案Go
- oracle goldengate 引數詳解(轉MOS:Oracle GoldenGates ample parameter files)OracleGo
- kettle 引數——變數引數和常量引數變數
- C#中的值引數,引用引數及輸出引數C#
- iOS可變引數(不定引數)的用法iOS
- 常用的jvm配置引數 :永久區引數配置JVM
- Oracle引數-隱藏引數Oracle
- 什麼是請求引數、表單引數、url引數、header引數、Cookie引數?一文講懂HeaderCookie
- Swift語言中為外部引數設定預設值可變引數常量引數變數引數輸入輸出引數Swift變數
- c# 方法引數_值引數C#
- c# 方法引數_引用引數C#
- 動態引數,靜態引數
- sendEmail帶的引數AI
- Mybatis的引數-parameterTypeMyBatis
- EXPDP的parallel引數Parallel