Repository Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.1
- 10.5

Back Next

MX View Categories

MX views provide information to help you analyze metadata stored in the repository.

The following table lists the available MX views by category:

Category	Description
Database	Provides a list of database definitions in the repository.
Sources	Provides a list of source definitions by folder.
Targets	Provides a list of target definitions by folder.
Mappings and Mapplets	Provides a list of sources, targets, and transformations used in mappings and mapplets by folder.
Metadata Extensions	Provides details of metadata extensions defined for objects.
Transformations	Provides details of transformation instances by folder.
Workflows, Worklets, and Tasks	Provides static and run time details for workflows and worklets by folder.
Security	Provides user information.
Deployment	Provides deployment details such as deployment groups and objects that were deployed from one repository to another.
Repository	Provides repository details such as repository name and connection information.
Integration Service	Provides details such as server name and host name.
Change Management	Provide version history of object and label details.
Folders	Provides details such as folder name and description.

For example, if a source table changes, and you need to re-import the source definition into the repository, you could use the REP_SRC_MAPPING view to see how many mappings include this source. Likewise, if you want to view source and target dependencies for a mapping, you could use REP_TBL_MAPPING.

Almost all views support access to comment information. You can add comments to any object within PowerCenter through the Designer and Workflow Manager. You can access comments about individual tables, table relationships, data fields, and data transformations.

Use these views to create reports using third-party reporting tools, such as Crystal Reports.

MX facilitates the integration of decision support metadata between the PowerCenter repository and popular Decision Support System (DSS) tools, data modeling tools, and any other metadata resources. With MX, you can drill down to the operational metadata level and expose information needed to support decisions. MX also helps you make precise information requests that draw from data models, mappings, and transformation data. For IS professionals, the MX architecture provides the following benefits:

Improves warehouse maintenance and management capability.

Reduces time and resources required to support end-user requests.

Expands the ability to provide information resources in a controlled manner.

The Designer includes options to save MX data.

MX Views Overview

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal