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
  17. Appendix B: PowerCenter Reports Reference

Repository Guide

Repository Guide

REP_TASK_ATTR

REP_TASK_ATTR

This view displays the attribute values and overridden values for session and workflow tasks.
The following table lists attribute information in the REP_TASK_ATTR view:
Column Name
Datatype
Description
WORKFLOW_ID*
NUMBER
Workflow ID.
INSTANCE_ID*
NUMBER
Task instance ID.
TASK_ID*
NUMBER
Task ID.
TASK_TYPE
NUMBER
Task type.
REF_SESSION_ID*
NUMBER
Session ID.
TASK_TYPE_NAME
VARCHAR2 (240)
Task type name.
ATTR_ID
NUMBER
Task attribute ID.
ATTR_NAME
VARCHAR2 (240)
Task attribute name.
ATTR_VALUE
VARCHAR2 (2000)
Attribute value.
LINE_NO
NUMBER
Line number of attribute values. Used for storing multiple lines of attribute values.
GROUP_ID*
NUMBER
Group ID.
VERSION_NUMBER*
NUMBER
Workflow version number if task attribute is overridden at workflow level. Session version number if task attribute is overridden at session level.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!