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_TARG_MAPPING

REP_TARG_MAPPING

This view provides access to the compound table-level transformation expressions for each target table. This view pulls information from all the transformation objects that contribute to the target table in a valid mapping. This view contains information about mappings defined for target tables. It does not contain information about sources.
Use the REP_TBL_MAPPING view to analyze source and target relationships. Join REP_TBL_MAPPING and REP_TARG_MAPPING by MAPPING_NAME to include column-level mapping information in the REP_FLD_MAPPING view.
The following table lists expression information in the REP_TARG_MAPPING view:
Column Name
Datatype
Description
TARGET_NAME*
VARCHAR2 (240)
Target name.
TARG_BUSNAME
VARCHAR2 (240)
Target business name.
SUBJECT_AREA*
VARCHAR2 (240)
Folder name.
MAPPING_NAME*
VARCHAR2 (240)
Mapping name.
VERSION_ID
INTEGER
Folder version ID.
VERSION_NAME
VARCHAR2 (240)
Folder version name.
SOURCE_FILTER
VARCHAR2 (2000)
Compound source filter condition.
CONDITIONAL_LOAD
VARCHAR2 (2000)
Compound conditional load.
GROUP_BY_CLAUSE
VARCHAR2 (2000)
Compound group by expression.
SQL_OVERRIDE
VARCHAR2 (2000)
Compound SQL override expression.
DESCRIPTION
VARCHAR2 (2000)
Description of transformation expression.
MAPPING_COMMENT
VARCHAR2 (2000)
Description of mapping.
MAPPING_LAST_SAVED
VARCHAR2 (30)
Time the mapping was saved last.
MAPPING_VERSION_NUMBER
NUMBER
Mapping version number.
TARGET_VERSION_NUMBER
NUMBER
Target version number.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!