Search

PowerExchange for HANA User Guide for PowerCenter

PowerExchange for HANA User Guide for PowerCenter

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

Back Next

Enabling Array Upsert for PowerExchange for HANA

Enabling Array Upsert for PowerExchange for HANA

You can configure an upsert operation to upsert data in bulk and improve the session performance

Before you upsert data into SAP HANA targets, configure the following properties:

EnableArrayUpsert=Yes: Add the EnableArrayUpsert custom property and set the value to yes for the PowerCenter Integration Service in the Administrator tool.; If you want to set the custom property in the HANA session properties, click the Properties
tab in the HANA session properties.; In the advanced section, in the Custom Properties
field, add the attribute EnableArrayUpsert
and set the value to yes
.
Treat Source Rows As: In the General options section, enter Update
as the Treat Source Rows As
property.
Update Else Insert: On the Mapping
tab, select the target and then enable the Update Else Insert
property.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.