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"

Leave a Comment

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
*
*