Informatica help

Informatica help and metadata report query

All Objects Used in a Mapping

All Objects Used in a Mapping

Displays source, targets and all transformations used in a mapping by repository and folder.


Click on the text to copy the query report to your clipboard.


select "REPOSITORY_NAME",
"INSTANCE_NAME",
"WIDGET_TYPE_NAME",
"SUBJECT_AREA",
"MAPPING_NAME",
"DESCRIPTION"
from (SELECT  DISTINCT      MAPPING_REPOSIT_INFO.REPOSITORY_NAME as REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA as SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME as MAPPING_NAME,  MAPPING_WIDGET_INST.WIDGET_TYPE_NAME as WIDGET_TYPE_NAME,  MAPPING_WIDGET_INST.INSTANCE_NAME as INSTANCE_NAME,  MAPPING_WIDGET_INST.DESCRIPTION as DESCRIPTION  FROM  REP_ALL_MAPPINGS ALL_MAPPINGS,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO,  REP_WIDGET_INST MAPPING_WIDGET_INST  WHERE  (ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID AND  ALL_MAPPINGS.PARENT_MAPPING_ID = MAPPING_WIDGET_INST.MAPPING_ID AND  ALL_MAPPINGS.PARENT_MAPPING_VERSION_NUMBER = MAPPING_WIDGET_INST.  VERSION_NUMBER AND ALL_MAPPINGS.PARENT_SUBJECT_ID = MAPPING_WIDGET_INST.SUBJECT_ID)) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPING_NAME" in ('<Mapping_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA", "MAPPING_NAME", "WIDGET_TYPE_NAME", "INSTANCE_NAME"