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.
- Relationship label
- Displayed when Relationships provided at runtime is set to NO.
- Relationship label field
- Displayed when Relationships provided at runtime is set to YES.
- 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.
- 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.