Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | MAPPING_ELEMENT |
| Short Name | MAP |
| View Name | CI_MAPPING_ELEMENTS |
| Description | A MAPPING_ELEMENT represents an individual mapping between two |
| elements for the purposes of a transformer | |
| For example, a mapping from the conceptual level of entity object | |
| 'Employee' to table 'EMPLOYEES' at the physical design (ie server) | |
| level | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: TRANSFORMATION_MAPPING_SET versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TRANSFORMATION_SET_REFERENCE SOURCE_CIELEMENT_REFERENCE TARGET_CIELEMENT_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_MAP |
| Changes: | Summary of changes to MAPPING_ELEMENT in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| TARGET_CIELEMENT_REFERENCE | N |
Prompt: Target Element
Transferable only if null |
Must be targeted to one and only one CIELEMENT | 133 |
| SOURCE_CIELEMENT_REFERENCE | N |
Prompt: Source Element
Transferable only if null |
Must be sourced from one and only one CIELEMENT | 134 |
| TRANSFORMATION_SET_REFERENCE | N |
Prompt: Transformation Mapping Set
Transferable only if null |
Must be within one and only one TRANSFORMATION_MAPPING_SET | |
| PRIMARY_MAPPING_REFERENCE | Y |
Not displayed
Transferable only if null |
May be a secondary mapping within one and only one MAPPING_ELEMENT | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| CREATED_BY_TRANSFORMER_FLAG | VARCHAR2(1) | N | Indicates whether the mapping was created by the transformer, ie as opposed to created by hand by the user.
Prompt: Created by Transformer ? Uppercase System maintained Not updatable by user | YESNO | N |
| ROLE_NAME | VARCHAR2(30) | Y | Name of the role that this mapping element plays in the transformation. Internal property supplied by, and for the use of, the transformer.
Not displayed Updatable only if null | ||
| SOURCE_ELEMENT_TYPE | VARCHAR2(6) | N | Arc 134 discriminator. Internal property indicating the type of element that is the source in the mapping
Prompt: Source Element Type Uppercase Updatable only if null | MAP_SOURCE_ELEMENT_TYPE | |
| TARGET_ELEMENT_TYPE | VARCHAR2(6) | N | Arc 133 doscriminator. Internal property indicating the type of element that is the target in the mapping
Prompt: Target Element Type Uppercase Updatable only if null | MAP_TARGET_ELEMENT_TYPE | |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| Other Properties |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference MAPPING_ELEMENT:
Note: