Repository Guide

10.5.4
- 10.5.7
- 10.5.6
- 10.5.1
- 10.5
- 10.4.0

Back Next

Mapping and Mapplet Views

Mapping and mapplet views allow you to see the sources, targets, and transformations used in a mapping or a mapplet by folder in a PowerCenter repository. These views also display properties of mappings and mapplets such as description, version and creation date, validity of the mapping or mapplet, and whether the mapping or mapplet is a shortcut.

When you save MX data for mappings, PowerCenter creates a field expression for each target field in the mappings. The field expression describes the source definition and transformation corresponding to the target field. In addition to viewing the MX data in MX views, you can view the field expressions in the Main window of the Repository Manager when you analyze source-target dependencies.

MX views do not provide field expressions for all transformations. MX views provide field expressions for Expression, Aggregator, Rank, Lookup, Stored Procedure, External Procedure, Router, Custom, and Normalizer transformations. All other transformations produce NULL values in the TRANS_EXPRESSION column for views such as the REP_TARG_FLD_MAP view.

The following table lists the different views that help you analyze mapping and mapplet metadata:

View	Description
REP_ALL_MAPPINGS	This view provides a list of the latest version of all mappings defined in each folder of a repository.
REP_ALL_MAPPLETS	This view provides a list of the latest version of all mapplets defined in each folder of a repository.
REP_TARG_MAPPING	This view provides access to the compound table-level transformation expressions for each target table.
REP_TARG_FLD_MAP	This view shows compound field-level transformation expressions associated with a target.
REP_FLD_MAPPING	This view shows the source fields used by the target fields in a mapping. This is the companion view for the REP_TBL_MAPPING view.
REP_SRC_MAPPING	This view shows all sources used in a mapping.
REP_SRC_FLD_MAP	This view shows all of the source fields used in a mapping.
REP_TBL_MAPPING	This view shows all of the target tables used in a mapping and provides source to target mapping information.
REP_TARG_TBL_JOINS	This view contains join information between target tables.
REP_MAPPING_CONN_PORTS	This view displays the port-level connections between the objects of a mapping.
REP_MAPPING_UNCONN_PORTS	This view displays the unconnected ports in sources, targets, and transformations in a mapping.