Relationship Configuration

The Relationship configuration determines how relationships are created between source and target entities.

You can specify a name for the new relationship label and add one or more connections, or you can select a relationship label from an existing model. Connections are determined by the configurations of the source and target entities.

Relationships provided at runtime
This setting allows you to specify whether the input source contains a field with the relationship label.
  • YES—Select this option if your input source contains a field with the relationship label.
  • NO—Select this option to specify the relationship label here.
Relationship label
Displayed when Relationships provided at runtime is set to NO.
Specify the name for the relationship label. For an existing model, you can choose a relationship from the drop down list.
Relationship label field
Displayed when Relationships provided at runtime is set to YES.
Select a field from the input source that contains the relationship label.
Connections
Shows relationships between the source and target entities. Choose source and target identifiers that you want to include in the relationship. Connections are defined by the source and target entity configurations.
Allow more than one relationship based on unique ID
To allow a relationship to be created more than once between a source and target entity, check this check box. Then in the drop-down list box, select the source field on which to base the relationship.

Properties

For each connection, options on this tab map property names to source fields. The mapping depends on whether you are defining properties for a known relationship label or a new relationship label. For a known relationship label, you map source fields to the property names. For a new relationship label, you select source fields and enter names to define properties.

Update mode
Choose how Write to Model manages property updates. After a relationship is created it can be updated over time when data with the same Relationship ID is input into the Write to Model stage.
  • Always update properties—Properties are always updated with the most recent information. This includes updating with null or empty strings.
  • Update properties unless all input is null—Properties are always updated unless all input fields associated with the selected properties are null.
  • Never overwrite non-empty properties—Properties are always updated unless the input is a null or empty string.
  • Never overwrite properties with empty input data—Properties are never updated once populated with non-empty data.
These settings are unavailable when Write mode is set to Initial load. For more information, see Write mode.
Property name
Specifies the name of a relationship property. For a known relationship, this column is populated with property names from the relationship. For a new relationship, enter a property name in this column for each selected source field. By default, the property name is the source field name.
Source field
Specifies the source field of a relationship property. For a known relationship, select a source field that maps to a property. For a new relationship, select the source fields in this column that will populate relationship properties. Choose None if there is no source field that maps to a property.

Conditions

For each connection settings on this tab specify conditions that control whether to create a relationship between a source and a target entity.

Add Conditions
Click this button to add conditions to a relationship.
Logical operator
This field is visible when you add a second or succeeding condition. Click And or Or to specify how a condition is applied in combination with preceding conditions. The And operator displays a record if a condition and preceding condition are both true. The Or operator displays a condition when either the condition or the preceding condition are true. A relationship is added if the entire sequence of conditions evaluates to true.
Data source
Select whether a condition applies to an Input field, a Source property (on the source entity), or a Target property (on the target entity).
Name field
Click to select the field or property name to which the condition applies.
Operator
Click to select the operator that defines the condition.
Value
Enter the condition value acted on by the operator.
Add condition button
Click this button to add a condition.
Delete condition button
Click this button to delete a condition.