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_FLD_MAP

REP_TARG_FLD_MAP

This view shows compound field-level transformation expressions associated with a target. This view pulls information from all transformation objects that contribute to the target table in a valid mapping. There might be many mappings for a set of fields, each distinguished by the MAPPING_NAME field. The field-level expression contains all the source fields (both file definition/non-relational source) that determine the value of the target field.
The following table lists expression metadata that you find in the REP_TARG_FLD_MAP view:
Column Name
Datatype
Description
TARGET_COLUMN_NAME
VARCHAR2 (240)
Name of target field (table field).
TARG_COL_BUSNAME
VARCHAR2 (240)
Business name of target field.
TARGET_NAME
VARCHAR2 (240)
Name of target (table).
TARG_BUSNAME
VARCHAR2 (240)
Business name of target table.
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.
TRANS_EXPRESSION
VARCHAR2 (2000)
Compound transformation expression.
USER_COMMENT
VARCHAR2 (2000)
End user comment.
DBA_COMMENT
VARCHAR2 (2000)
Administrator comment.
MAPPING_COMMENT
VARCHAR2 (2000)
Mapping comment.
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.

0 COMMENTS

We’d like to hear from you!