PowerExchange for Salesforce User Guide for PowerCenter

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1

Back Next

Handling Null Values in Update and Upsert Operations

By default, the PowerCenter Integration Service does not replace existing values in a Salesforce record with null values from the source during an update or upsert operation. To replace existing values with null values, configure the Set Fields to NULL session property for the Salesforce target.

You cannot set the value of an external ID field in a Salesforce target to null. The session fails if you enable the Set Fields to NULL session property and the session tries to replace an existing value for an external ID field with a null value.

Configuring a Session with a Salesforce Target

Disassociate a Child Object

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal