Informatica help

Informatica help and metadata report query

Mapping Shortcuts

Mapping Shortcuts

Displays mappings defined as a shortcut by repository and folder.


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


select "PARENT_MAPPING_LAST_SAVED",
"PARENT_MAPPING_DESCRIPTION",
"SUBJECT_AREA",
"PARENT_MAPPING_VERSION_NUMBER",
"MAPPING_NAME",
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",
"REPOSITORY_NAME",
"MAPPING_VERSION_NUMBER",
"MAPPING_DESCRIPTION",
case when ("PARENT_MAPPING_VERSION_STATUS" = 0) then ('Active') else (case when ("PARENT_MAPPING_VERSION_STATUS" = 9) then ('Logically Deleted') else (case when ("PARENT_MAPPING_VERSION_STATUS" = 10) then ('Physically Deleted') else ('') end) end) end as "Calc_PARENT_MAPPING_VERSION_ST",
"MAPPING_LAST_SAVED",
"PARENT_MAPPING_NAME",
case when ("SHORTCUTFLAG" = 1) then ("PARENT_SUBJECT_AREA") else ('') end as "Calc_IS_SHORTCUT1",
case when ("SHORTCUTFLAG" = 1) then ('Yes') else ('No') end as "Calc_ShortcutFlag"
from (SELECT  MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,  ALL_MAPPINGS.MAPPING_DESCRIPTION        AS MAPPING_DESCRIPTION,  ALL_MAPPINGS.MAPPING_VERSION_NUMBER,  ALL_MAPPINGS.MAPPING_VERSION_STATUS,  ALL_MAPPINGS.MAPPING_LAST_SAVED,  ALL_MAPPINGS.IS_SHORTCUT as SHORTCUTFLAG,  ALL_MAPPINGS.PARENT_SUBJECT_AREA ,  ALL_MAPPINGS.PARENT_MAPPING_NAME ,  ALL_MAPPINGS.PARENT_MAPPING_DESCRIPTION AS PARENT_MAPPING_DESCRIPTION,  ALL_MAPPINGS.PARENT_MAPPING_VERSION_NUMBER ,  ALL_MAPPINGS.PARENT_MAPPING_VERSION_STATUS ,  ALL_MAPPINGS.PARENT_MAPPING_LAST_SAVED ,  ALL_MAPPINGS.PARENT_MAPPING_IS_VALID as VALIDFLAG,  (COUNT(DISTINCT(MAPPING_SESS_PARTITION_DEF.SESSION_ID)))        AS SESSION_ID  FROM  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO,  REP_ALL_MAPPINGS ALL_MAPPINGS    LEFT OUTER JOIN REP_SESS_PARTITION_DEF MAPPING_SESS_PARTITION_DEF    ON ALL_MAPPINGS.PARENT_MAPPING_ID = MAPPING_SESS_PARTITION_DEF.   MAPPING_ID  WHERE  (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.IS_SHORTCUT,  ALL_MAPPINGS.PARENT_SUBJECT_AREA ,  ALL_MAPPINGS.PARENT_MAPPING_NAME ,  ALL_MAPPINGS.PARENT_MAPPING_DESCRIPTION ,  ALL_MAPPINGS.PARENT_MAPPING_VERSION_NUMBER ,  ALL_MAPPINGS.PARENT_MAPPING_VERSION_STATUS ,  ALL_MAPPINGS.PARENT_MAPPING_LAST_SAVED ,  ALL_MAPPINGS.PARENT_MAPPING_IS_VALID,  ALL_MAPPINGS.MAPPING_LAST_SAVED) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and case when ("SHORTCUTFLAG" = 1) then ('Yes') else ('No') end = 'Yes'
order by "REPOSITORY_NAME", "SUBJECT_AREA"

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