Store changes
These settings are only available when the Store changes replication mode is enabled.
On update
資訊備註This setting is not relevant for SaaS application sources as changes are applied as INSERT operations.
Select Store before and after image to store both the pre-UPDATE data and the post-UPDATE data. When not selected, only the post-UPDATE data will be stored.
Change table creation
If change table exists when full load starts: Select one of the following to determine how to load the Change Tables when Full Load replication starts:
- Drop and create change table: The table is dropped and a new table is created in its place.
- Delete old changes and store new changes in existing change table: Data is truncated and added without affecting the table metadata.
- Keep old changes and store new changes in existing change table: Data and metadata of the existing Change table are not affected.
Table header columns
變更表格標頭欄提供關於變更處理操作的資訊，例如操作類型 (例如插入)、認可時間等。若您不需要此所有資訊，可以設定 移動 任務，以建立含所選標頭欄 (或完全不含) 的變更表格，藉此降低在目標資料庫中的所占空間。
資訊備註您無法在任務執行時移除其他欄或還原欄。若要變更您的初始選項，您需要先停止任務，然後修改選項，最後載入目標表格。
For a description of the header columns, see 變更表格.