- 新しい順
- 投票が多い順
- コメントが多い順
Hi,
Glad to hear that it was answered!
Please also note that the extra fields that you are observing in the CSV files is as per the expected behavior as additional fields are added to each migrated record when migrating with AWS DMS to an S3 bucket. As you correctly mentioned, additional fields indicate the operation applied to the record at the source database i.e. field contains the letter I (INSERT), U (UPDATE), or D (DELETE) to indicate whether the row was inserted, updated, or deleted at the source database.
This behavior can be controlled based on the migration type and by configuring the Extra Connection Attributes, includeOpForFullLoad, cdcInsertsOnly, and cdcInsertsAndUpdates.
To know more about this in detail, kindly refer the below documentation [+]:
[+] Indicating source DB operations in migrated S3 data - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html#CHAP_Target.S3.Configuring.InsertOps
This was answered in another post by @Pulkit_B. https://repost.aws/questions/QUCqKo0aqQTjGc37B48Usdcg/dms-migration-task-is-not-creating-cdc-files-when-source-endpoint-is-s-3
At some point the PreserveTransactionProperty was removed but the cdc-path remained.
関連するコンテンツ
- AWS公式更新しました 2年前
@Deepam - Thanks for the response. I read the documentation and have one question. When the task is set to full load and ongoing. Do these files represent the changes that occur while full load is running and prior to CDC starting. I just want to verify that the changes in these files will not also be captured by cdc.