When the target is same as the source, you can only perform an update operation.

When the target is different from the source, you can select the following task operations:

Insert

Ignores existing target data and inserts source data.

Update

Updates data in the target location based on source data.

Upsert

Updates existing target data. If data does not exist in the target, the

masking

task inserts data.

You can perform update, upsert, and insert operations on a partial sandbox. When you run an inplace masking task, you can perform an update operation. If the target is different from the source, you can perform insert and upsert operations.