BDM - Model Repository Service (MRS)

> Data Integration Tool (ETL/ELT) > Big Data Management Informatica (BDM)

1 - About

The Model Repository Service is an application service that manages the Model repository.

The Model Repository Service manages metadata about:

The Model repository stores metadata created by Informatica clients and application services in a relational database to enable collaboration among the clients and services.

Advertising

3 - Management

3.1 - Infra

Application Service Guide Chapter 9

3.2 - MRX Views

The MRX views provide an interface to interrogate information about objects in the MRS. That information is more limited than the information provided by the MX views in a PowerCenter repository.

The reason for that is because the data is kept in tables in binary format as a stream in the same format that Java serializes objects. That’s why that information is not shown decrypted and accessible as in a PowerCenter Repository.

MRX views are classified into the following categories:

  • Design-time metadata
  • Deployed metadata
  • Domain

3.2.1 - Object

The MRX_OBJECT_SUMMARY view 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.

To track the changes or modified details, query on the view for OBJECT_NAME. It will list the following:

CREATED_BY CREATION_TIME LAST_MODIFIED_BY LAST_UPDATED_TIME MRX_OBJECT_SUMMARY view is only available from Informatica 9.5.1 onwards.

Time is stored in EPOCH time

Advertising

3.3 - Log

Enable spy logging on MRS connection to:

  • get the details on the SQL queries used to create MRS tables.​

4 - Documentation / Reference

dit/bdm/mrs.txt · Last modified: 2018/11/21 12:51 by gerardnico