Invoke SmartMapper Operations

Use the SmartMapper Wizard activity to invoke a batch of relationship lookup operations, entity lookup operations, and mapping maintenance operations.

Lookup Relationship (xref_lookup)

This operation takes a participant input and returns an output participant. The two participants are the parameters. Multiple instances are returned if the output participant is in the many relationship.

If the input evaluates to null, a lookup is not performed. Such a lookup returns null unless you select the check box to throw an exception.

Field Description
Input Participant The participant used to look up.
Note: Same ER Model must be used throughout the activity.
Output Participant The participant that is being looked-up.
Error on Empty Result When selected, the activity throws an exception if the lookup fails to find the output participant. If this check box is cleared, see the Verbose field description in the General tab.

Lookup Entity (xref_lookup)

With this operation, you can look up entities according to the input data.

Field Description
Entity Specify the entity is being looked up.
Note: Same ER Model must be used throughout the activity.
Error on Empty Result When selected, the activity throws an exception if the lookup fails to find the output participant. If this box is cleared, see the Verbose field description under the General tab.

Maintain Mapping - One to One (xref_map)

This operation maintains a one-to-one mapping between two participants. This operation creates and associates two entity instances within a relationship instance. The creation/association only occurs if the relationship instance does not already exist.

Field Description
Participant Select the two participants that are being maintained.

Maintain Mapping - One to Many (xref_map)

This operation maintains a one-to-many mapping. This operation employs the same semantics as the previous Maintain Mapping operation, but this operation also creates and associates entity instances in a one-to-many mapping.

Field Description
Participant (One) The participant on the one side or many side of the one-to-many association.
Participant (Many) The participant on the many side of the one-to-many association. This participant must have selected the Cardinality Is Many check box in the ER Model definition.
Validation Option Choose a validation behavior when the relationship instance already exists:
  • Existing entries must match: in this case, the values passed into the Input tab must match the existing values with no additions or removal of entries on the many side of the relationship.
  • Replace exiting entries: in this case, the values passed into the Input tab are meant to replace any existing values on the many side of the relationship.
  • Add any new entries: in this case, the values passed into the Input tab are to be added if they do not already exist in the many side of the relationship.
Note:
  • If the input value does not exist in one relationship instance and the selected option is not NONE, SmartMapper Wizard creates a new relationship instance.
  • If the input value exists in one relationship instance and the selected option is Add any new entries, SmartMapper Wizard creates nothing.
  • The participant of many side cannot be empty no matter if it is a TIBCO-Managed entity.