BDM - Model Repository Service (MRS)

Bdm Component

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.

Management

Infra

Application Service Guide Chapter 9

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

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

Log

Enable spy logging on MRS connection to:

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

Documentation / Reference





Discover More
Bdm Component
BDM - Application

From the mrs repo,
Bdm Component
BDM - Connection

BDM connections: HBase (a NoSQL database comprising key-value pairs on Hadoop that performs operations in real-time) Hadoop, HDFS, Hive connections JDBC With List the properties /...
Cluster Config Bdm
BDM - Installation in Azure

Open the node Domain > ClusterConfigurations Right Click > Import With Cluster Connection (if with file convention: , such as Hive_ccMapR.) Information from the cluster (needed for during the configuration...
Mapping As Query
BDM - Mapping

BDM - Mapping From the mrs repo Lists all the mappings and mapplets available in the Model Repository service. With create and saved times. FAQ:...
Bdm Component
BDM - Model repository

The Model repository stores profiles, data domains, mapping, and workflows that you manage in the Developer tool. The Model repository also stores profiles, data domains, and mapping specifications that...
Bdm Component
BDM - Project

list of all projects, use another view MRX_PROJECTS query to get the project\folder object path information from Model Repository Service (MRS) with at least one folder
Bdm Component
BDM - Services

BDM infa application services available on a domain Analyst Service. The Analyst Service runs the Analyst tool in the Informatica domain. The Analyst Service manages the connections between service...
Bdm Component
BDM - Sqoop

Sqoop within BDM. The Model Repository Service uses JDBC to import metadata. The Data Integration Service runs the mapping in the Hadoop run-time environment and pushes the job processing to Sqoop....
Bdm Component
BDM - Workflow

workflow. from : FAQ: How to retrieve workflow details in Model Repository Views? EPOCH time
Bdm Component
BDM - infacmd

infacmd is a command line client of BDM. Powercenter In the informatica INFA_HOME/isp/bin/ (First) but also: INFA_HOME/server/bin directory Usage: where module: ISP to manage the...



Share this page:
Follow us:
Task Runner