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

Target Views

Target Views

Target views provide a list of the latest version of all target definitions defined by folder of a PowerCenter repository for both relational and non-relational sources. These views also show target properties such as shortcuts, creation date, version, description, and business name. They also provide information such as target columns, column properties, target metadata extensions, and mappings and mapplets where these target are used.
The following table lists the different views that help you analyze target metadata:
View
Description
REP_ALL_TARGETS
This view provides a list of the latest version of all targets defined in each folder of a repository.
REP_ALL_TARGET_FLDS
This view provides all the fields and field properties for targets defined in REP_ALL_TARGETS view.
REP_TARG_TBLS
This view provides a list of targets in the repository. FIRST_COLUMN_ID is a link to the set of columns for this table.
REP_TARG_TBL_COLS
This view provides the properties of columns defined for the target tables in a data warehouse or data mart.

0 COMMENTS

We’d like to hear from you!