Use to create and configure reusable mappings in Oracle Data Integrator.
A reusable mapping is a mapping fragment that can be included in mappings or other reusable mappings. A reusable mapping can define zero to many input and output signatures to pass data from and to the included mapping. Similar to a regular mapping, a reusable mapping can also include datastores as sources and targets, as well as other components.
The Reusable Mapping Editor is organized into three main tabs. Each main tab is made up of several sub-tabs and components:
Reusable Mapping Editor Logical Tab, also called the Logical Diagram
The logical mapping rules from input to output signatures are defined in the Logical tab of the Reusable Mapping Editor.
The Logical Diagram contains components that are linked through connectors with arrow heads pointing the direction of the flow from source to target. Each component has left and right connector ports to anchor incoming and outgoing connectors.
In order to create a Logical Diagram perform the following steps:
Drag and drop input and output signature components from the Component Palette into the appropriate areas. Add attributes to signatures as necessary. You might use the attribute matching capabilities (see: Attribute Matching Dialog) later to populate the signatures with attributes from other components.
If applicable, drag and drop datastores or reusable mappings from the designer navigator into the diagram. Source datastores and reusable mappings can also be organized within a Dataset Component.
Drag and drop components such as joins, filters, or others from the component palette into the component area to define rules for the reusable mapping between input and output signatures. If datasets are used, join, lookup, or filter rules can be defined by dragging attributes between datastores and onto the dataset background.
Create connectors between components by dragging from the originating connector port to the destination connector port. Connectors can also be implicitly created by dragging attributes between components. When creating a connector between two ports, an Attribute Matching Dialog may be shown to automatically map attributes based on name or position.
Set component properties, expressions, and conditions by selecting components and editing the properties in the Property Inspector.
| Properties | Description |
|---|---|
| Name | Name of the reusable mapping. |
| Description | Detailed description of the reusable mapping. |
| Target Load Order | List of targets that are loaded in a defined order. Uses the Target Load Order Dialog to select and order targets. |
"Reusable Mappings" in the "Creating and Using Mappings" chapter in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator