Mapping List

Displays mappings by repository and folder. It also displays properties of the mapping such as the number of sources used in a mapping, the number of transformations, and the number of targets.

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


select "WIDGET_TYPE5",
"WIDGET_TYPE4",
"WIDGET_TYPE6",
"REPOSITORY_NAME",
"MAPPING_VERSION_NUMBER",
"SUBJECT_AREA",
case when ("MAPPING_VERSION_STATUS" = 0) then ('Active') else (case when ("MAPPING_VERSION_STATUS" = 9) then ('Logically Deleted') else (case when ("MAPPING_VERSION_STATUS" = 10) then ('Physically Deleted') else ('') end) end) end as "Calc_MAPPING_VERSION_STATUS",
case when ("IS_SHORTCUT1" = 1) then ('Yes') else ('No') end as "Calc_IS_SHORTCUT1",
"MAPPING_NAME",
"MAPPING_LAST_SAVED",
"DESCRIPTION",
case when ("PARENT_MAPPING_IS_VALID" = 1) then ('yes') else ('No') end as "Calc_PARENT_MAPPING_IS_VALID",
case when ("IS_SHORTCUT2" = 1) then ('ALL_MAPPINGS.PARENT_SUBJECT_AREA') else ('') end as "Calc_IS_SHORTCUT2",
"WIDGET_TYPE1",
"WIDGET_TYPE2",
"WIDGET_TYPE3"
from (SELECT  MAPPING_REPOSIT_INFO.REPOSITORY_NAME              AS REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA                         AS SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME                         AS MAPPING_NAME,  ALL_MAPPINGS.MAPPING_DESCRIPTION AS DESCRIPTION,  ALL_MAPPINGS.MAPPING_VERSION_NUMBER               AS MAPPING_VERSION_NUMBER,  ALL_MAPPINGS.MAPPING_VERSION_STATUS               AS MAPPING_VERSION_STATUS,  ALL_MAPPINGS.MAPPING_LAST_SAVED                   AS MAPPING_LAST_SAVED,  ALL_MAPPINGS.IS_SHORTCUT                          AS IS_SHORTCUT1,  ALL_MAPPINGS.PARENT_SUBJECT_AREA                  AS PARENT_SUBJECT_AREA,  ALL_MAPPINGS.IS_SHORTCUT                          AS IS_SHORTCUT2,  ALL_MAPPINGS.PARENT_MAPPING_IS_VALID              AS PARENT_MAPPING_IS_VALID  ,  (COUNT(   CASE    WHEN MAPPING_WIDGET_INST.WIDGET_TYPE = 1    THEN MAPPING_WIDGET_INST.INSTANCE_ID   END))                                 AS WIDGET_TYPE1,  (COUNT(   CASE    WHEN MAPPING_WIDGET_INST.WIDGET_TYPE = 2    THEN MAPPING_WIDGET_INST.INSTANCE_ID   END))                                 AS WIDGET_TYPE2,  (COUNT(   CASE    WHEN MAPPING_WIDGET_INST.WIDGET_TYPE NOT IN (1,   2,   44)    THEN MAPPING_WIDGET_INST.INSTANCE_ID   END))                                 AS WIDGET_TYPE3,  (COUNT(   CASE    WHEN MAPPING_WIDGET_INST.WIDGET_TYPE = 44    THEN MAPPING_WIDGET_INST.INSTANCE_ID   END))                                 AS WIDGET_TYPE4,  (COUNT(DISTINCT(   CASE    WHEN MAPPING_WIDGET_INST.WIDGET_TYPE = 1    THEN MAPPING_WIDGET_INST.WIDGET_ID   END)))                               AS WIDGET_TYPE5,  (COUNT(DISTINCT(   CASE    WHEN MAPPING_WIDGET_INST.WIDGET_TYPE = 2    THEN MAPPING_WIDGET_INST.WIDGET_ID   END)))                               AS WIDGET_TYPE6  FROM  REP_ALL_MAPPINGS ALL_MAPPINGS,  REP_WIDGET_INST MAPPING_WIDGET_INST,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO  WHERE  (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 AND  ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID)  GROUP BY  MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,  ALL_MAPPINGS.MAPPING_DESCRIPTION,  ALL_MAPPINGS.MAPPING_VERSION_NUMBER,  ALL_MAPPINGS.MAPPING_VERSION_STATUS,  ALL_MAPPINGS.PARENT_SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_LAST_SAVED,  ALL_MAPPINGS.IS_SHORTCUT,  ALL_MAPPINGS.PARENT_MAPPING_IS_VALID) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPING_NAME" in ('<Mapping_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA", "MAPPING_NAME", "DESCRIPTION", "MAPPING_VERSION_NUMBER", "Calc_MAPPING_VERSION_STATUS", "MAPPING_LAST_SAVED", "Calc_IS_SHORTCUT1", "Calc_IS_SHORTCUT2", "Calc_PARENT_MAPPING_IS_VALID"