You can perform update, upsert, and delete operations after you define a primary key in the target table. The Secure Agent does not retain the primary key information of a Teradata table during metadata import. You must therefore select the target columns in the

Update Columns

field in the target properties. The target columns serve as a key when you run an update, upsert, or delete operation.