Informatica help

Informatica help and metadata report query

Mapping Sources

Mapping Sources

Displays sources defined in a mapping by repository and folder.


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


select "SOURCE_DESCRIPTION",
"SOURCE_NAME",
"REPOSITORY_NAME",
"PARENT_SOURCE_DATABASE_TYPE",
"MAPPING_NAME",
"PARENT_SOURCE_BUSINESS_NAME",
case when ("SOURCE_VERSION_STATUS" = 0) then ('Active') else (case when ("SOURCE_VERSION_STATUS" = 9) then ('Logically Deleted') else (case when ("SOURCE_VERSION_STATUS" = 10) then ('Physically Deleted') else ('NULL') end) end) end as "Calc_SOURCE_VERSION_STATUS",
"SOURCE_VERSION_NUMBER",
"SOURCE_DATABASE_NAME",
case when ("IS_SHORTCUT" = 1) then ('Yes') else ('No') end as "Calc_IS_SHORTCUT",
"SUBJECT_AREA"
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_ALL_SOURCES.SOURCE_DATABASE_NAME AS SOURCE_DATABASE_NAME,   MAPPING_ALL_SOURCES.SOURCE_NAME AS SOURCE_NAME,   MAPPING_ALL_SOURCES.PARENT_SOURCE_BUSINESS_NAME AS PARENT_SOURCE_BUSINESS_NAME,   MAPPING_ALL_SOURCES.SOURCE_DESCRIPTION AS SOURCE_DESCRIPTION,   MAPPING_ALL_SOURCES.SOURCE_VERSION_NUMBER AS SOURCE_VERSION_NUMBER,   MAPPING_ALL_SOURCES.SOURCE_VERSION_STATUS AS SOURCE_VERSION_STATUS,   MAPPING_ALL_SOURCES.PARENT_SOURCE_DATABASE_TYPE AS PARENT_SOURCE_DATABASE_TYPE,   MAPPING_ALL_SOURCES.IS_SHORTCUT AS IS_SHORTCUT  FROM   REP_ALL_MAPPINGS ALL_MAPPINGS,   REP_REPOSIT_INFO MAPPING_REPOSIT_INFO,   REP_WIDGET_INST MAPPING_WIDGET_INST,   REP_ALL_SOURCES MAPPING_ALL_SOURCES   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 AND   MAPPING_ALL_SOURCES.PARENT_SOURCE_ID = MAPPING_WIDGET_INST.WIDGET_ID AND   MAPPING_ALL_SOURCES.SUBJECT_ID = MAPPING_WIDGET_INST.SUBJECT_ID AND  MAPPING_WIDGET_INST.WIDGET_TYPE = 1 )) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPING_NAME" in ('<Mapping_Name>')
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