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_WIDGET_FIELD

REP_WIDGET_FIELD

This view displays field level details for transformations.
The following table lists transformation field information in the REP_WIDGET_FIELD view:
Column Name
Datatype
Description
WIDGET_ID*
NUMBER
Transformation ID.
FIELD_NAME
VARCHAR2 (240)
Transformation field name.
FIELD_ID*
NUMBER
Transformation field ID.
WGT_PREC
NUMBER
Transformation field precision.
WGT_SCALE
NUMBER
Transformation field scale.
WGT_DATATYPE
NUMBER
Transformation field data type.
PORTTYPE
NUMBER
Transformation port type.
FIELD_ORDER
NUMBER
Transformation order.
DESCRIPTION
VARCHAR2 (2000)
Comments on the field.
PROPERTY
NUMBER
Field-level property used by transformations.
DEFAULT_VALUE
VARCHAR2 (2000)
Default value of the transformation field.
SRC_FIELD_ID*
NUMBER
Source field ID for normalizer transformation.
GROUP_ID*
NUMBER
ID of the corresponding instance in the mapplet's mapping.
VERSION_NUMBER*
NUMBER
Transformation version number.
DATATYPE_NUM
NUMBER
Datatype number.
DATATYPE
VARCHAR2 (40)
Transformation datatype of the port.
DATATYPE_GROUP_CODE
CHAR (1)
Datatype group code.
DATABASE_TYPE
VARCHAR2 (20)
External database type.
EXPRESSION
VARCHAR2 (2000)
Expression name.
EXPR_DESCRIPTION
VARCHAR2 (2000)
Comments on the expression.
EXPR_TYPE
NUMBER
Expression type.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!