Search code examples
sqldatabaseoracle-databaseinformaticainformatica-powercenter

Sql Query to get Mappings names under a particular folder from Informatica Database?

Can anyone please help me out

Sql Query to get Mappings names under a particular folder from Informatica Database

Solution


  • you can get mapping_names using this query

    SELECT
M.MAPPING_NAME MAPPING,
CASE WHEN M.IS_VALID = 1 THEN 'YES' ELSE 'NO' END IS_VALID,
FROM OPB_MAPPING M, OPB_SUBJECT S
WHERE M.SUBJECT_ID = S.SUBJ_ID
AND is_visible = 1;

    So what do you mean under a folder?