Foreign keys can now be defined and added in the data dictionary of the source and destination providers, including Gateway. 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>
Legal Notices
Copyright © 2013, 2015,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, March 25, 2015