Database View Reference

Database View Reference

MRX_TX_SOURCES

MRX_TX_SOURCES

The MRX_TX_SOURCES view provides information about all mappings and mapping sources.
The following table describes the source and mapping information in the MRX_TX_SOURCES view:
Column Name
Datatype
Description
MAPPING_ID
NUMBER
Mapping ID.
MAPPING_NAME
VARCHAR(1536)
Mapping name.
DOINST_ID
NUMBER
Data object instance ID in a mapping.
DOINST_NAME
VARCHAR(3060)
Data object instance name in a mapping.
DATA_OBJECT_ID
NUMBER
Data object ID.
You can view the following data objects:
  • Physical objects
  • Logical objects
DATA_OBJECT_NAME
VARCHAR(4000)
Data object name.
You can view the following data objects:
  • Physical objects
  • Logical objects
DATA_OBJECT_TYPE
VARCHAR(14)
Data object type.
You can view the following data object types:
  • Mainframe
  • SAP
  • File
  • Logical
  • Relational

0 COMMENTS

We’d like to hear from you!