BDM - Project

Management

List

• list of all projects, use another view MRX_PROJECTS

select * from MRX_PROJECTS
-- View is based on the table
SELECT * FROM PO_MPPROJECT;

• query to get the project\folder object path information from Model Repository Service (MRS) with at least one folder

select *, project_name, object_path from MRX_OBJECT_SUMMARY where OBJECT_TYPENAME like 'com.informatica.metadata.common.folder.impl.FolderImpl' order by