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

Transformation Views

Transformation Views

Transformation views display details of all reusable and non-reusable transformation instances by folder in a PowerCenter repository. These views also display properties such as attributes, dependencies, port-level connections, and field level details of transformations.
The following table lists the different views that help you analyze transformation metadata:
View
Description
REP_ALL_TRANSFORMS
This view provides a list of the latest version of all transformations and their properties in each folder of a repository.
REP_WIDGET_INST
This view displays the details of all transformation instances.
REP_WIDGET_DEP
This view displays the details of dependencies between transformation instances in a mapping.
REP_WIDGET_ATTR
This view displays attribute details for transformations, instances, and sessions.
REP_WIDGET_FIELD
This view displays field level details for transformations.

0 COMMENTS

We’d like to hear from you!