When you import a target definition, define a column as a key field for applying update strategies. Define the update strategy in the session properties. This column identifies the documents for performing operations such as update or delete documents.

For example, an Employee form in a Notes database contains EmpID, JoiningDate, and Phone fields. You want to update the contact details for the employees who have moved recently. These details are stored in a relational database.

The following table shows sample data for the Employee form in a Notes database:

The following table shows the sample data in a relational table:

Import the Employee form as a target definition. Define the EmpID as the key field. Import the Contact Details table as a source definition.

The PowerCenter Integration Service selects documents based on the key field to perform the update strategy operations. The PowerCenter Integration Service updates the following records in the Employee form based on the EmpID field: