Use to automatically generate mappings to extract data from the datastores of a given data model. The automatically generated mappings are based on the existing mappings used to load data into these datastores.These mappings invert the existing data flows targeting this model.
Mappings OUT are generated using the mappings (including the mappings IN) that are already loading the model's datastores. They invert the integration process to propagate the data from the composite datastore to the original datastores.
For a given model or datastore assembled using Common Format Designer, Oracle Data Integrator is able to generate mappings OUT.
Note:
The Generate Mappings OUT command does not take shortcuts into account.Specify the following parameters in the Generate Mappings OUT editor:
Optimization Context: The context used for creating the mappings. This context is used to automatically generate the flow of the mappings.
Generation Folder: Oracle Data Integrator project folder into which the mappings are generated.
You can click Search, to search for the project folder or click Clear Folder Selection if you want to remove the folder specified in this field.
This list displays the datastores from the current model as the Target Tables. For each of these datastores, if Oracle Data Integrator is able to find a datastore for which the data flow can be inverted, it presents it as a Candidate Datastore.
Select the Generation/Generate Mapping check box to generate mappings for all or some of the candidate datastores attached to a given target table. Click Select all the suggested mappings if you want to select all mappings.
Edit the Mapping Name attribute to rename the generated mappings.
"Generating Mapping IN/OUT" in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator