Each group in the target business component contains a field that determines the update strategy for the group. Configure this field in the mapping to specify the operation that you need to perform on the rows. You can perform INSERT, UPDATE, and DELETE operations on rows. The default operation is INSERT.

The following table lists the valid values for the update strategy field:

If you specify an invalid value for this field, the PowerCenter Integration Service treats it as INSERT.

The naming convention for the update strategy field is Update_Strategy_<group_name>. The Account group contains the Update_Strategy_Account field and the Business_Address group contains the Update_Strategy_Business_Address field.

The following table shows the rows contained in the source definition Account_Src:

The following table shows the rows contained in the source definition Business_Add_Src:

In this example, each source represents a group in the target definition. To maintain key relationships when you connect mapping objects, connect source columns to the corresponding group in the target definition.

The following table lists the column relationships between the source definitions and the groups in the Account target definition:

The following figure shows the Account business component with a multi-valued field:

The PowerCenter Integration Service inserts the following rows into the target business component: