Informatica help

Informatica help and metadata report query

Associations by Package

Associations by Package

Lists all associations in a specified package. Associations identify the relationship between classes in a metamodel.


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


select "ORIGINATOR_NAME",
"FROM_CLASS_NAME",
"ASSOCIATION_NAME",
"FROM_CARDINALITY",
"MODIFIED_ON",
"ASSOCIATION_DESC",
"TO_CARDINALITY",
"PACKAGE_NAME",
"TO_CLASS_NAME"
from (SELECT  DISTINCT MMR_ASSOC_PACKAGE.ORIGINATOR_NAME,  MMR_ASSOC_PACKAGE.PACKAGE_NAME,  MMR_IMA_ASSOCIATION.ASSOCIATION_NAME,  MMR_IMA_ASSOCIATION.ASSOCIATION_DESC,  MMR_FROM_CLASS.CLASS_NAME AS  FROM_CLASS_NAME,  MMR_IMA_ASSOCIATION.FROM_CARDINALITY,  MMR_TO_CLASS.CLASS_NAME  AS  TO_CLASS_NAME,  MMR_IMA_ASSOCIATION.TO_CARDINALITY,  CONVERT(VARCHAR,MMR_IMA_ASSOCIATION.MODIFIED_ON,23)   AS MODIFIED_ON FROM  IMA_ASSOCIATION MMR_IMA_ASSOCIATION,  IMA_CLASS MMR_TO_CLASS,  IMA_PACKAGE MMR_ASSOC_PACKAGE,  IMA_CLASS MMR_FROM_CLASS  WHERE  (MMR_IMA_ASSOCIATION.TO_CLASS_UID = MMR_TO_CLASS.CLASS_UID AND  MMR_IMA_ASSOCIATION.PACKAGE_UID = MMR_ASSOC_PACKAGE.PACKAGE_UID AND  MMR_IMA_ASSOCIATION.FROM_CLASS_UID = MMR_FROM_CLASS.CLASS_UID)) "query"
where "ORIGINATOR_NAME" in ('<Originator_Name>') and "PACKAGE_NAME" in ('<Package_Name>')
order by "ORIGINATOR_NAME", "PACKAGE_NAME", "ASSOCIATION_NAME", "ASSOCIATION_DESC", "FROM_CLASS_NAME", "FROM_CARDINALITY", "TO_CLASS_NAME", "TO_CARDINALITY", "MODIFIED_ON"