Oracle Data Integrator Support for Cross Referencing
Oracle Data Integrator (ODI) achieves data integration through an E-LT (extract, load, transform) model. You can use ODI to help with your cross-referencing needs. ODI provides three Knowledge Modules for handling SOA cross references that perform the following functions: Populate the cross-reference table, create a common ID for the target table, push the common ID and the source primary key to the cross-reference table, and create and push a unique row number that creates the cross reference between the source primary key and the common ID. With the modules, you can create an integration interface that both loads a target table from several source tables and handles cross-references between one of the sources and the target.
For more information about ODI and cross referencing, see Oracle SOA Suite Cross References in Connectivity and Knowledge Modules Guide for Oracle Data Integrator Developer's Guide.