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_VERSION_PROPS

REP_VERSION_PROPS

This view provides the version history of all objects in a PowerCenter repository.
The following table lists label information in the REP_VERSION_PROPS view:
Column Name
Datatype
Description
OBJECT_ID*
NUMBER
Object ID.
OBJECT_TYPE*
NUMBER
Object type ID (primary key).
OBJECT_SUBTYPE
NUMBER
Object subtype ID.
IS_SHORTCUT
NUMBER
Specifies whether the object is a shortcut.
1 = shortcut; 0 = not a shortcut.
VERSION_NUMBER
NUMBER
Object version number.
SUBJECT_ID
NUMBER
Folder ID.
USER_ID
NUMBER
User who last modified this version of the object.
OBJECT_NAME
VARCHAR2 (240)
Name of the object.
GROUP_NAME
VARCHAR2 (240)
Database name used by source objects.
LAST_SAVED
VARCHAR2 (30)
Time when object was last saved.
UTC_LAST_SAVED
NUMBER
UTC time when the object was last modified.
COMMENTS
VARCHAR2 (2000)
Description of the object.
SAVED_FROM
VARCHAR2(240)
Host machine name from which the version of the object is saved.
PURGED_BY_USERID
NUMBER
User ID who purged the object from the repository.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!