Powercenter Mappings by Folder

This query will provide you a lists PowerCenter repository mappings by the folder in which each mapping resides.


 

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


select "NAME_PATH",
"CHILD_ELEMENT_NAME",
"ELMNT_ATTR_VALUE",
"REPOSITORY_NAME",
"ELEMENT_NAME"
from (SELECT DISTINCT ODS_IMA_ELEMENT.REPOSITORY_NAME, ODS_IMA_ELEMENT.ELEMENT_NAME, ODS_IMA_CHILD_ELEMENT.ELEMENT_NAME as CHILD_ELEMENT_NAME, ( SELECT EA.ELMNT_ATTR_VALUE FROM IMA_ELMNT_ATTR EA WHERE EA.CLASS_ATTR_NAME = 'infa_description' AND EA.ELEMENT_UID = ODS_IMA_CHILD_ELEMENT.ELEMENT_UID ) as ELMNT_ATTR_VALUE , ODS_IMA_CHILD_ELEMENT.NAME_PATH as NAME_PATH FROM IMA_ELMNT_ASSOC ODS_IMA_CHILD_ELMNT_ASSOC, IMA_ELEMENT ODS_IMA_CHILD_ELEMENT, IMA_ELEMENT ODS_IMA_ELEMENT, IMA_ELMNT_ATTR ODS_IMA_CHILD_ELMNT_ATTR WHERE (ODS_IMA_CHILD_ELMNT_ASSOC.TO_ELEMENT_UID = ODS_IMA_CHILD_ELEMENT. ELEMENT_UID AND ODS_IMA_CHILD_ELMNT_ASSOC.FROM_ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID AND ODS_IMA_CHILD_ELMNT_ATTR.ELEMENT_UID = ODS_IMA_CHILD_ELEMENT.ELEMENT_UID) AND (ODS_IMA_CHILD_ELMNT_ATTR.CLASS_ATTR_NAME = 'name' AND ODS_IMA_CHILD_ELEMENT.CLASS_TYPE = 'Mapping' AND ODS_IMA_ELEMENT.CLASS_TYPE = 'Folder' AND ODS_IMA_ELEMENT.DELETED_FLAG = 'N' )) "query"
where "REPOSITORY_NAME" in ('<Repository_Name>') and "ELEMENT_NAME" in ('<Folder/Version_Name>')
order by "REPOSITORY_NAME", "ELEMENT_NAME", "CHILD_ELEMENT_NAME", "ELMNT_ATTR_VALUE", "NAME_PATH"

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*