PowerExchange for SAP NetWeaver User Guide for PowerCenter

10.5.6
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Session Properties for SAP ECC Targets

You can configure session properties for SAP ECC targets in the Targets view on the Mapping tab. Define the properties for each target instance in the session. When you click the Targets view on the Mapping tab, you can view and configure the settings of a specific target. Select the target under the Targets node.

The following table describes the properties available in the Properties settings on the Mapping tab of the session properties:

Attribute Name	Description
Target load type	You can choose Normal or Bulk. If you select Normal, the PowerCenter Integration Service loads SAP ECC targets normally. If you select Bulk, the PowerCenter Integration Service loads all the rows in a packet to SAP ECC targets at the same time. Loading in bulk mode can improve session performance. Default is Normal.
Packet Size	Set the packet size that the PowerCenter Integration Service commits table data to SAP. Packet size determines the maximum number of rows the PowerCenter Integration Service stores in its buffer before it makes an RFC call to the SAP system. Default is 10000.
Insert	Integration Service inserts all rows flagged for insert. Default is enabled.
Update	Select one of the Update options. None. PowerCenter Integration Service does not update any rows. Update as Update. PowerCenter Integration Service updates all rows flagged for update. Default option. Update as Insert. PowerCenter Integration Service inserts all rows flagged for update. Update else Insert. PowerCenter Integration Service updates rows flagged for update if they exist in the target, else inserts the rows.
Delete	PowerCenter Integration Service deletes all rows flagged for delete. Default is enabled.
Truncate target table option	PowerCenter Integration Service truncates the target before loading. Default is disabled.
Reject file directory	Reject file directory name. By default, the Integration Service writes all reject files to the service process variable directory, $PMBadFileDir.
Reject file name	File name for the reject file.
Target Table name	You can override the default target table name.
Update Override	Overrides the UPDATE statement in the target definition Properties tab.

You cannot configure a target connection group when you write data to SAP tables.

Rename Saved Search

Table of Contents

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Session Properties for SAP ECC Targets

Session Properties for SAP ECC Targets