0
Completed

Join transformation handle type conversion

Adam van Vliet 9 years ago updated by anonymous 7 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.

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>