Informatica data modeling Table and Views Summary report

Lists tables and views by Model.

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


select "MODEL_NAME",
"OBJECT_NAME",
"REPOSITORY_NAME",
"OBJECT_TYPE",
"LX_LOCATION",
"DESCRIPTION"
from (SELECT  DISTINCT ODS_IMA_ELEMENT.REPOSITORY_NAME,  ODS_IMA_PARENT_ELEMENT.ELEMENT_NAME AS MODEL_NAME,  ( SELECT    EA.ELMNT_ATTR_VALUE    FROM    IMA_ELMNT_ATTR EA    WHERE    EA.CLASS_ATTR_NAME = 'infa_type' AND    EA.ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID  ) AS OBJECT_TYPE  ,  ODS_IMA_ELEMENT.ELEMENT_NAME AS OBJECT_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 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 = 'Data Modeling' AND  ODS_IMA_ELEMENT.CLASS_TYPE IN ('View',  'Table') AND  ODS_IMA_ELMNT_ATTR.CLASS_ATTR_NAME = 'name' AND  ODS_IMA_ELEMENT.DELETED_FLAG LIKE '%N%' )) "query"
where "REPOSITORY_NAME" in ('<Repository_Name>')
order by "REPOSITORY_NAME", "MODEL_NAME", "OBJECT_TYPE", "OBJECT_NAME"