Update Mode Setting

If the Mode setting is Update, lookup is performed based on the primary participant, and if no instance is found, a new one is created. If a lookup returns an existing relationship instance, it is replaced with the new participant.

Note: Only one participant can be lookupParticipant. The other participant can be either lookupParticipant or unlinkParticipant.

There are two participants, P1 and P2. The lookupParticipant value of the P1 participant is 1, which means that the lookup is performed for a relationship instance based on this participant.

If there is a P2 unlinkParticipant (value 1), then the given value in its field ( b200) is replaced with the value given for the Replacement Participant (b2001).

If there is no P2 unlinkParticipant (value 0), then the existing values in the database (such as b2003, b2004, b2005) are replaced with the value given for the Replacement Participant (b2001). When there are no values to replace, a new value (b2001) is added.

The following figure shows the input of the Bulk Load activity where the Input format is set to One Participant Relationship Format and the Mode is set to Update.