Repository Guide

10.5.6
- 10.5.7
- 10.5.4
- 10.5.1
- 10.5
- 10.4.0

Back Next

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.