Foreign keys can now be defined and added in the data dictionary of the source and destination providers, including Gateway from the Gateway user interface or in the XML description file as shown below. Once defined, the mapping can then be defined in a mapping template.
<FieldMapTemplates>
<App1Name>Sample</App1Name>
<App2Name>P6</App2Name>
<FieldMapTemplate>
<Description>Demonstrating mapping foreign key in a mapping template</Description>
<App1BusinessObjectName>Operation</App1BusinessObjectName>
<Name>Sample Mapping Template</Name>
<PDIBusinessObjectName>Activity</PDIBusinessObjectName>
<FieldMap>
<App1>SampleWorkOrderElementId</App1>
<App2>SampleWBSObjectId</App2>
<PDI>SampleWBSObjectId</PDI>
</FieldMap>
</FieldMapTemplate>
</FieldMapTemplates>
In the metadata XML file or the customization XML file, mark the field as a foreign key and set the JoinTo to the name of the object that this field is joining to as in the example below:
<Field>
<Description>Sample WBS Object IDs</Description>
<Name>SampleWBSObjectId</Name>
<JoinTo>WBS</JoinTo>
<Type>ForeignKey</Type>
</Field>