Repository Guide

10.5.7
- 10.5.6
- 10.5.4
- 10.5.1
- 10.5
- 10.4.0

Back Next

Source Views

Source views provide a list of the latest version of all source definitions defined by folder of any PowerCenter repository. Source definitions can be defined for both relational and non-relational sources. These views also show source properties such as shortcuts, creation date, version, description, and business name. They also provide information such as source columns, column properties, source metadata extensions, and mappings and mapplets where these sources are used.

The following table lists the different views that help you analyze source metadata:

View	Description
REP_ALL_SOURCES	This view provides a list of the latest version of sources defined in each folder of a repository.
REP_ALL_SOURCE_FLDS	This view provides all the fields and field properties for all sources defined in REP_ALL_SOURCES MX View.
REP_SRC_FILES	This view provides a list of all file definitions in the repository.
REP_SRC_TBLS	This view provides a list of relational database table sources that have been analyzed through the Source Analyzer tool or imported from a DDL (Data Definition Language) file.
REP_SRC_FILE_FLDS REP_SEG_FLDS	These views provide access to the fields in a non-relational source.
REP_SRC_TBL_FLDS	This view provides access to the fields in relational sources. Use the source name to retrieve all the fields belonging to the source.