Informatica help

Informatica help and metadata report query

Mapping List

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"

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast