Informatica help

Informatica help and metadata report query

Class Association

Class Association

Displays all attributes of the specified class, including its inherited attributes from parent classes.


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


select "TO_PACKAGE_NAME",
"PACKAGE_NAME",
"FROM_PACKAGE_NAME",
"ASSOCIATION_NAME",
"FROM_CARDINALITY",
"TO_CLASS_NAME",
"FROM_CLASS_NAME",
"ORIGINATOR_NAME",
"TO_CARDINALITY",
"MODIFIED_ON"
from (SELECT  DISTINCT MMR_ASSOC_PACKAGE.ORIGINATOR_NAME,  MMR_ASSOC_PACKAGE.PACKAGE_NAME,  MMR_FROM_CLASS.CLASS_NAME AS  FROM_CLASS_NAME,  MMR_FROM_CLASS.PACKAGE_NAME FROM_PACKAGE_NAME,  MMR_IMA_ASSOCIATION.ASSOCIATION_NAME,  MMR_IMA_ASSOCIATION.FROM_CARDINALITY,  MMR_TO_CLASS.CLASS_NAME    as  TO_CLASS_NAME,  MMR_TO_CLASS.PACKAGE_NAME  AS TO_PACKAGE_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>') and "FROM_CLASS_NAME" in ('<Class_Name>')
order by "ORIGINATOR_NAME", "PACKAGE_NAME", "ASSOCIATION_NAME", "FROM_PACKAGE_NAME", "FROM_CLASS_NAME"

Has one comment to “Class Association”

You can leave a reply or Trackback this post.
  1. nissim229 - Oct 19, 2017 Reply

    Hi,

    Not sure what you mean

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast