The Relationships Tab

After determining the entities for your model, you need to establish the relationships between source and target entities on the Relationships tab. These relationships represent the connection between two entities (for example, John Smith is a customer of ABC Enterprises, Inc.). As with entities, relationships may also contain properties, which you may or may not choose to include in your model.

1. Select the field that contains the source entity ID in the Source ID field.
2. If the source entity type is contained in its own field, check the Type in separate field box and select the appropriate field in the Type drop-down.
3. Select the field that contains the relationship between the source and target in the Label drop-down.
4. If you want to allow a relationship to be created more than once between a source and target entity, click the Allow more than one relationship based on unique ID box and select the field on which to base the relationship in the Unique ID drop-down.
5. Select the field that contains the target entity ID in the Target ID field.
6. If the target entity type is contained in its own field, check the Type in separate field box and select the appropriate field in the Type drop-down.
7. The Field Name grid includes all the fields from your entity input file. Select the fields whose data you want included in the model by clicking the Include box for those fields.
8. Click OK.