Informatica data base management Synonyms for Database Structures report

Lists database synonyms and the tables using those synonyms.


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


select "BASE_OBJECT_TYPE",
"REPOSITORY_NAME",
"OBJECT_DESCRIPTION",
"SYNONYM_DESCRIPTION",
"BASE_OBJECT_NAME",
"SYNONYM_NAME",
"SCHEMA_NAME1"
from (SELECT  DISTINCT ODS_IMA_ELEMENT.REPOSITORY_NAME AS REPOSITORY_NAME,  ODS_IMA_PARENT_ELEMENT.ELEMENT_NAME AS SCHEMA_NAME1 ,  ODS_IMA_ELEMENT.CLASS_TYPE  AS Base_OBJECT_TYPE,  ODS_IMA_CHILD_ELEMENT.ELEMENT_NAME AS SYNONYM_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 SYNONYM_DESCRIPTION,  ODS_IMA_ELEMENT.ELEMENT_NAME AS BASE_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 Object_DESCRIPTION  FROM  IMA_ELMNT_ASSOC ODS_IMA_CHILD_ELMNT_ASSOC,  IMA_ELEMENT ODS_IMA_CHILD_ELEMENT,  IMA_ELEMENT ODS_IMA_ELEMENT,  IMA_ELMNT_ASSOC ODS_IMA_ELMNT_ASSOC,  IMA_ELEMENT ODS_IMA_PARENT_ELEMENT,  IMA_ELMNT_ATTR ODS_IMA_ELMNT_ATTR,  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_ELMNT_ASSOC.FROM_ELEMENT_UID = ODS_IMA_PARENT_ELEMENT.ELEMENT_UID   AND  ODS_IMA_ELMNT_ASSOC.TO_ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID AND  ODS_IMA_ELMNT_ATTR.ELEMENT_UID = ODS_IMA_ELEMENT.ELEMENT_UID AND  ODS_IMA_CHILD_ELMNT_ATTR.ELEMENT_UID = ODS_IMA_CHILD_ELEMENT.ELEMENT_UID)   AND  (ODS_IMA_PARENT_ELEMENT.PRODUCT_TYPE = 'Database Management' AND  ODS_IMA_PARENT_ELEMENT.CLASS_TYPE IN ('Schema',  'Database',  'User') AND  ODS_IMA_CHILD_ELEMENT.CLASS_TYPE = 'Synonym' AND  ODS_IMA_ELEMENT.CLASS_TYPE IN ('Table',  'View') AND  ODS_IMA_ELMNT_ATTR.CLASS_ATTR_NAME = 'name' AND  ODS_IMA_CHILD_ELMNT_ATTR.CLASS_ATTR_NAME = 'name' AND  ODS_IMA_ELEMENT.DELETED_FLAG = 'N' )) "query"
order by "REPOSITORY_NAME", "SCHEMA_NAME1", "BASE_OBJECT_TYPE", "SYNONYM_NAME", "SYNONYM_DESCRIPTION"

1 Comment

  1. I am writing to you to inquire as to whether you have any jobs or work that I can perform in the fields of Data Entry and Virtual Assistance. I am an American expat presently living in New Delhi, India. I have experience in Data Entry, Virtual Assistance, and I can perform any work that you may require as long as it can be done online or remotely. If you would like to see my resume please let me know and I’ll gladly send it over to you. Or you can check my online resume at my own site at http://www.CoreyCananza.comPlease contact me through the Contact Me page at my website. Thank you for your consideration.Warm Regards,Corey Cananza

Leave a Comment

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

*
*