The Model Repository Service manages metadata about:
- and applications.
The Model repository stores metadata created by Informatica clients and application services in a relational database to enable collaboration among the clients and services.
Application Service Guide Chapter 9
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
Enable spy logging on MRS connection to:
- get the details on the SQL queries used to create MRS tables.