Informatica help

Informatica help and metadata report query

Invalid Mapping Targets

Invalid Mapping Targets

Displays targets in an invalid mapping by repository and folder.


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


select case when ("IS_SHORTCUT" = 1) then ('Yes') else ('No') end as "Calc_IS_SHORTCUT",
"SUBJECT_AREA",
"TARGET_VERSION_NUMBER",
"REPOSITORY_NAME", "TARGET_NAME",
"PARENT_TARGET_DATABASE_TYPE", "TARGET_DESC",
"PARENT_TARGET_BUSINESS_NAME",
"MAPPING_NAME",
case when ("TARGET_VERSION_STATUS" = 0) then ('Active') else (case when ("TARGET_VERSION_STATUS" = 9) then ('Logically Deleted') else (case when ("TARGET_VERSION_STATUS" = 10) then ('Physically Deleted') else ('') end) end) end as "Calc_TARGET_VERSION_STATUS"
from (SELECT  DISTINCT MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,  MAPPING_ALL_TARGETS.TARGET_NAME,  MAPPING_ALL_TARGETS.PARENT_TARGET_BUSINESS_NAME,  MAPPING_ALL_TARGETS.TARGET_DESCRIPTION as TARGET_DESC,  MAPPING_ALL_TARGETS.TARGET_VERSION_NUMBER,      MAPPING_ALL_TARGETS.TARGET_VERSION_STATUS,  MAPPING_ALL_TARGETS.PARENT_TARGET_DATABASE_TYPE,      MAPPING_ALL_TARGETS.IS_SHORTCUT,      ALL_MAPPINGS.PARENT_MAPPING_IS_VALID as VALIDFLAG   FROM  REP_ALL_TARGETS MAPPING_ALL_TARGETS,  REP_WIDGET_INST MAPPING_WIDGET_INST,  REP_ALL_MAPPINGS ALL_MAPPINGS,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO   WHERE  (MAPPING_ALL_TARGETS.PARENT_TARGET_ID = MAPPING_WIDGET_INST.WIDGET_ID AND  MAPPING_ALL_TARGETS.SUBJECT_ID = MAPPING_WIDGET_INST.SUBJECT_ID AND  MAPPING_WIDGET_INST.WIDGET_TYPE = 2 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 AND  ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID)) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and case when ("VALIDFLAG" = 1) then ('Yes') else ('No') end = 'No'
order by "REPOSITORY_NAME", "SUBJECT_AREA", "MAPPING_NAME", "TARGET_NAME", "PARENT_TARGET_BUSINESS_NAME"

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