Creating and update row transform on delete

Use Case

Upon deletion of a row in the source database the desired behavior is to update a timestamp column on the target database that signifies the deletion but does not delete the row in the target.

Solution

1.) Create a new transform with a "Delete Action" set to "UPDATE_COL"

2.) Select the "Edit Columns" button after the transform is created and setup a transform that uses the target column for deletes only and with a variable type. This will result in the target row not being deleted but instead simply having the transform column updated with the current timestamp.