PowerExchange for Siebel User Guide for PowerCenter

10.5.4
- 10.5.5
- 10.2

Back Next

Configuring the Update Strategy

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:

Operation	Value
INSERT	0
UPDATE AS UPDATE	1
DELETE	2
UPDATE ELSE INSERT	3

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

The PowerCenter Integration Service ignores the value of the Treat Source Rows As property at the session level.

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:

GPK__Account	Update_Strategy_Account	Name	ID
1	0	James Brown	101
2	0	John Martin	102

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

GPK__Business_Address	GFK__Account_Business_Address	City	Street Address
A	1	Los Angeles	63 Ranch Ave
B	1	Frankfort	3090 Stevens Creek Blvd
C	2	Dallas	181 Curtner Ave
D	2	San Diego	760 Camino Real

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:

Source Name	Source Column Name	Account Target Group Name	Target Column Name
Account_Src	GPK__Account	Account	GPK__Account
Account_Src	Name	Account	Name
Account_Src	ID	Account	ID
Business_Addr_Src	GPK__Business_Address	Business_Address	GPK__Business_Address
Business_Addr_Src	GFK__Account__Business_Address	Business_Address	GFK__Account__Business_Address
Business_Addr_Src	City	Business_Address	City
Business_Addr_Src	Street_Address	Business_Address	Street_Address

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:

[Account (“James Brown”, “101”, Address (Los Angeles, 63 Ranch Ave), Address (Frankfort, 3090 Stevens Creek Blvd)]
[Account (“John Martin”, “102”, Address (Dallas, 181 Curtner Ave), Address (San Diego, 760 Camino Real)]

Rename Saved Search

Table of Contents

PowerExchange for Siebel User Guide for PowerCenter

PowerExchange for Siebel User Guide for PowerCenter

Configuring the Update Strategy

Configuring the Update Strategy