0
Completed

Join transformation handle type conversion

Adam van Vliet (Chief Information Security Officer) 5 years ago • updated by anonymous 3 years ago 2

The join transformation should handle type conversion.

This should be done using the schemaValidator.CreateValue or similar. Unfortunately this is made difficult by both sides being MultiKeyValue.

Affected Versions:
Fixed by Version:

It is the best that the conversion can be done during the comparison so that the attribute data type do not have to change. For example add "conversion" to Relationship tag as below

<Relationships>
<Relationship InputKey="OrgId" RelationshipKey="OBJID" Conversion = "Integer2String"/>
</Relationships>
<columnMappings>
<columnMapping SourceAttribute="SOBID" TargetAttribute="sapChiefPositionNumber" />
</columnMappings>