Add Mode Setting

If the Mode setting is Add, a participant with the Cardinality is many option selected cannot be assigned multiple values in the same relationship instance. Instead, each value must be assigned using a unique relationship instance.

When this mode is selected, only one participant is primary. That is, participant entries can be split across multiple relationship instances, but each relationship instance must contain one participant (primary participant) that is already included in some other relationship instance.

For examples, there are two participants, P1 and P2. P1 has the Cardinality is many option cleared (it has a one-to-one relationship) and P2 has the Cardinality is many option selected (it has a many-to-many relationship). P2 has two values assigned and each value is set in a different relationship instance.

Note: When there are multiple participants with one-to-one relationships defined, only one participant is displayed in subsequent relationship instances.

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 setting is set to Add.