Informatica

How to get Folders and Mapping names from Informatica Metadata Query

Saurav Mitra

We can use OPB_MAPPING and OPB_SUBJECT tables residing under informatica Repository to obtain information about all the mappings under each Informatica Folder. Following SQL query shows you how to do it.

Below SQL query that shows the names of all the Folders in the repository and the mappings contained in them along with last saved date, mapping version number and versioning comments, if any.

SELECT
  S.SUBJ_NAME FOLDER,
  M.MAPPING_NAME MAPPING,
  M.VERSION_NUMBER VERSION_NUMBER,
  CASE WHEN M.IS_VALID = 1 THEN 'YES' ELSE 'NO' END IS_VALID,
  M.LAST_SAVED SAVED_ON,
  M.CHECKOUT_USER_ID,
  M.COMMENTS
FROM OPB_MAPPING M, OPB_SUBJECT S
WHERE M.SUBJECT_ID = S.SUBJ_ID
AND is_visible = 1
ORDER BY 1, 2, 3;

NOTE: Please note that the above query result also shows all the mapplet present

Informatica Metadata Tables - Overview and Tutorial

How to get Informatica Repository Information from Metadata

Useful Informatica Metadata Repository Queries