Informatica help

Informatica help and metadata report query

Report Exploration

Report Exploration

This query will get you a lists reports by repository and folder to which it belongs.



select "REPORT_FOLDER_NAME",
"REPORT_NAME",
"REPOSITORY_NAME",
"REPORT_DESCRIPTION",
"LX_LOCATION"
from (SELECT DISTINCT ODS_IMA_ELEMENT.REPOSITORY_NAME, ODS_IMA_ELEMENT.ELEMENT_NAME AS REPORT_NAME, ODS_IMA_PARENT_ELEMENT.ELEMENT_NAME AS REPORT_FOLDER_NAME, ( SELECT EA.ELMNT_ATTR_VALUE FROM IMA_ELMNT_ATTR EA WHERE EA.CLASS_ATTR_NAME = 'infa_description' AND EA.ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID ) AS Report_DESCRIPTION , ODS_IMA_ELEMENT.NAME_PATH as LX_LOCATION FROM IMA_ELMNT_ASSOC ODS_IMA_ELMNT_ASSOC, IMA_ELEMENT ODS_IMA_ELEMENT, IMA_ELEMENT ODS_IMA_PARENT_ELEMENT, IMA_ELMNT_ATTR ODS_IMA_ELMNT_ATTR WHERE (ODS_IMA_ELMNT_ASSOC.TO_ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID AND ODS_IMA_ELMNT_ASSOC.FROM_ELEMENT_UID = ODS_IMA_PARENT_ELEMENT.ELEMENT_UID AND ODS_IMA_ELMNT_ATTR.ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID) AND (ODS_IMA_PARENT_ELEMENT.PRODUCT_TYPE = 'Business Intelligence' AND ODS_IMA_PARENT_ELEMENT.CLASS_TYPE = 'Folder' AND ODS_IMA_ELMNT_ATTR.CLASS_ATTR_NAME = 'name' AND ODS_IMA_ELEMENT.CLASS_TYPE = 'Report' AND ODS_IMA_ELEMENT.DELETED_FLAG = 'N' )) "query"
where "REPOSITORY_NAME" in ('<Repository_Name>')
order by "REPOSITORY_NAME", "REPORT_NAME", "REPORT_FOLDER_NAME", "REPORT_DESCRIPTION"

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