Kamal Kamal - 2 months ago 11
SQL Question

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

Answer


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?

Comments