Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. Appendix A: MX Views Reference

Repository Guide

Repository Guide

REP_MAPPING_CONN_PORTS

REP_MAPPING_CONN_PORTS

This view displays the port-level connections between the objects of a mapping. Objects include sources, targets, transformations, and mapplets. Unconnected transformations are not included.
The following table lists port-level connection metadata in the REP_MAPPING_CONN_PORTS view:
Column Name
Datatype
Description
SUBJECT_ID*
NUMBER
Folder ID.
SUBJECT_AREA
VARCHAR2 (240)
Folder name.
MAPPING_ID*
NUMBER
Sequence ID for the mapping (primary key).
MAPPING_NAME
VARCHAR2 (240)
Mapping name.
MAPPING_VERSION_NUMBER*
NUMBER
Mapping version number.
FROM_OBJECT_ID*
NUMBER
Source object ID.
FROM_OBJECT_TYPE
NUMBER
Source object type.
FROM_OBJECT_TYPE_NAME
VARCHAR2 (240)
Name of the source object type.
FROM_OBJECT_NAME
VARCHAR2 (240)
Source object name.
FROM_OBJECT_INSTANCE_ID*
NUMBER
Source object instance ID.
FROM_OBJECT_FIELD_NAME
VARCHAR2 (240)
Source object field name.
FROM_OBJECT_VERSION_NUMBER
NUMBER
Source object version number.
TO_OBJECT_ID*
NUMBER
Target object ID.
TO_OBJECT_TYPE
NUMBER
Target object type such as port, target, mapplet, and transformation.
TO_OBJECT_TYPE_NAME
VARCHAR2 (240)
Target object type name.
TO_OBJECT_NAME
VARCHAR2 (240)
Target object name.
TO_OBJECT_INSTANCE_ID*
NUMBER
Target object instance ID.
TO_OBJECT_FIELD_NAME
VARCHAR2 (240)
Target object field name.
TO_OBJECT_VERSION_NUMBER*
NUMBER
Target object version number.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!