Hi Iftach,

This is intentional. In Both the examples, I have kept the deleted record as is and can be identified by Op=’D’, this has been done intentionally to show the capability of DMS, however, the references below show how to convert this soft delete into a hard delete with minimal effort.

The example in the blog below shows the delete step.

https://aws.amazon.com/blogs/aws/new-insert-update-delete-data-on-s3-with-amazon-emr-and-apache-hudi/