Foreign Multi-value Group Transformation
Overview
The foreign multi-value group transformation is used to create a collection of values for entities that match the join criteria. In this regard, it is very similar to the group transformation. The difference is that the join occurs against values inside a multi-valued field in the relational target. the relational target can be either a connector or an adapter.
Use Cases
The membership list multi-value transformation can be used to accomplish the following:
- Generating a membership grouping for a relational target.
For example, imagine that there are two connectors:
Member
| Field | Type |
|---|---|
| MemberID | Integer |
| Name | String |
Group
| Field | Type |
|---|---|
| GroupID | Integer |
| GroupName | String |
| Members | Multi-value Integer |
A Foreign Multi-value Group transformation could be used to add a field to the Member object class, to define which Groups it belongs to.
Prerequisites
This transformation requires a relational target that can be a connector or an adapter.
Contribution
This transformation adds values from the relational entities, either by selecting one of their attributes or by defining a Distinguished Name template in a group target field.
Configuration
The membership list transformation requires the following by way of configuration:
| Attribute | Description |
|---|---|
| Group target | A relational target to be grouped on. This could be either a connector or an adapter.That is, this target contains the multi-value attribute used in the transformation. |
| Source Field | The field on the adapter side against which entities on the selected relationship target will be joined. |
| Join Field | The multi-value field on the relational target to join on. |
| Target | This is the key column name which is the target output of the group membership list. The generated values for each matching item will be added as multi-values to this field. |
| Simple Value | Select this if you want the target field to consist of simple values which are taken from an attribute of the matched items. |
| Generate Distinguished Names | Select this if you want the target field to be populated by generating Distinguished Names from the matched items. |
| Source | If Simple Values is selected, this determines which attribute of the matched items will be used to populate the target values. |
| Template | If Generate Distinguished Names is selected, this is the distinguished name template to be applied on the entities on the relational target side. The resulting values will be placed in the Target field. An adapter may be selected so that the generated distinguished names are full, UNIFYConnect distinguished names, otherwise, they are generated as seen. |
| Reference Field | Entities without a value in this field won't be considered for a join. |
The above configuration populates a _MemberOf_field with distinguished names where the Id field matches a Members value in the relational target.
Change Processing
During the change detection process, a change will be flagged if any of the relationship fields are changed.