This section contains information about general concepts applicable to the Mapping Editor. It contains the following topics:
Mapping components in the Logical Diagram flow have two different styles that affect how attributes are represented and can be mapped:
Projector components define their own attributes. Attributes from preceding components are mapped through expressions to the projector's attributes. A projector hides attributes from preceding components; all succeeding components can only use the attributes from the projector.
Built-in projector components:
Selector components reuse attributes from preceding components. Join and Lookup selectors combine attributes from the preceding components. For example, a Filter component following a datastore component reuses all attributes from the datastore component. As a consequence, with the exception of the Expression component, selector components do not display their own attributes in the diagram and as part of the properties; they are displayed as a round shape. When mapping to a component succeeding the selector component, the attribute can be directly dragged from the source, across a chain of connected selector components, to the target or next projector component.
Built-in selector components:
An attribute is a data field or column within a component. Depending on the type of component an attribute might have different properties.
| Properties | Description |
|---|---|
| Name | Name of the attribute. |
| Description | Detailed description of the attribute. |
| Data type | SQL datatype of the attribute. |
| Bound Object | Datastore component only.
Name of the bound base datastore attribute. |
The target tab is only shown for components accepting expressions, such as aggregate, distinct, expression, output signature, set, reusable mapping, or target datastore.
| Properties | Description |
|---|---|
| Expression | SQL expression to map to the attribute. This field provides an Expression Editor for graphical editing.
For a Set component the Expression property is a table with Expression and Execute on Hint for each Connection Point. |
| Execute on hint | Hint on which execution unit the expression is evaluated.
Possible values: |
| Fixed Execution Location | Specifies the actual logical schema that an expression shall be executed. Overrides Execute on hint for the expression of a target column. |
| Technical Description | Datastore component only
Provides a version of the join with all attribute names replaced by their descriptions. This field cannot be edited. |
| Active | Datastore component only
Indicates that the expression must be considered when executing the mapping. |
| Key | Datastore component only
Shows that the attribute participates in the update key for the mapping. |
| Insert | Datastore component only
Shows that this mapping attribute participates in the insertion operations in the target table. |
| Update | Datastore component only
Shows that this mapping attribute participates in the update operations in the target table. |
| Check Not Null (Flow control only) | Datastore component only
Shows that during the flow control, all the "not null" on this attribute must be verified. |
| UD 1 – UD 10 | Datastore component only
Shows that this attribute participates in the operations linked to User Defined 1 to 10. See the documentation of the KM in use for more information. |
| Properties | Description |
|---|---|
| Size | Logical length of the attribute, as it is functionally seen by the user. For a number, this is the total number of digits (Precision). |
| Scale | Number of digits contained in the decimal part of a numerical data type. |
"Defining New Attributes" in the "Creating and Using Mappings" chapter in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator