Database View Reference

10.5
- 10.5.4
- 10.4.0

Back Next

Model Repository Views Overview

Informatica provides a set of relational views that allow SQL access to the Model repository. The repository contains views that are used by other views. You do not need to query against the views used by other views.

The following table describes the Model repository views:

View	Description
MRX_APP_DETAILS	Provides application details such as application name and object information.
MRX_APP_SUMMARY	Provides application summary and path details about the applications within a project.
MRX_APPLICATION_STAT	Provides details about deployed applications.
MRX_COL_PROFILE_INFO	Provides the data source information for all the column profiles.
MRX_CONNECTIONS	Provides information about connections and connection types used across repositories in the Informatica domain.
MRX_LDO_DETAILS	Provides information about logical data objects such as source information with connection name.
MRX_LDO_SRCCNT	Provides the number of sources in logical data objects.
MRX_LDO_SUMMARY	Provides a summary of logical data objects, project, path, and the logical data model.
MRX_MAPPINGS	Provides information about all mappings.
MRX_MAP_SRCCNT	Provides information about number of data objects for each mapping.
MRX_OBJECT_SUMMARY	Provides a summary of objects. The view provides information about the project that the object belongs to, the object path, and user activity on the object.
MRX_PDO	Provides information about physical data objects and the path of the object in a project.
MRX_PROFILE_RULES	Provides rule details in all the profiles.
MRX_PROFILERUNSTAT	Provides information about the run-time statistics of profile objects that you create in the Model repository.
MRX_PROFILE_SUMMARY	Provides a summary of the profile objects.
MRX_RT_APP_DETAILS	Provides information about application objects of deployed applications within a Data Integration Service.
MRX_RT_APP_SUMRT	Gives information about deployed applications within a Data Integration Service.
MRX_RT_SQLDS_DETAILS	Provides details about SQL data services with schema, virtual table, and virtual stored procedures in deployed applications.
MRX_RT_SQLDS_SUMMARY	Provides details about design-time SQL data services.
MRX_SC_METRIC_GROUPS	Provides metric group information in all the scorecards.
MRX_SC_NONRULE_METRIC	Contains information on metrics in all the scorecards.
MRX_SC_RULE_METRICS	Contains information on rule metrics in all the scorecards.
MRX_SCORECARD_INFO	Provides basic scorecard information, such as name, description, and cost unit.
MRX_SQLDS_DETAILS	Provides details about SQL data services with schema, virtual table or stored procedures, and the sources used in the mappings of virtual tables.
MRX_SQLDS_SUMMARY	Provides a summary of SQL data services.
MRX_TX_SOURCES	Lists all mappings and their sources.
MRX_VT_PDO	Lists the sources used by virtual tables.

The Model repository tables have an open architecture. Although you can view the repository tables, Informatica strongly advises against altering the tables or data within the tables. Informatica is not responsible for corrupted data that is caused by customer alteration of the repository tables or data within those tables. Therefore, do not directly access the actual repository tables. Instead, use the Model Repository views to access the repository.

Rename Saved Search

Table of Contents

Database View Reference

Database View Reference

Model Repository Views Overview

Model Repository Views Overview