Informatica help

Informatica help and metadata report query

Class Attribute

Class Attribute

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 "CLASS_NAME",
"ORIGINATOR_NAME",
"CLS_ATTR_DEFAULT_VALUE",
"EDITABLE_FLAG",
"CLASS_ATTR_NAME",
"PRNT_CLASS_NAME",
"PACKAGE_NAME"
from (SELECT  DISTINCT MMR_IMA_CLASS.ORIGINATOR_NAME,  MMR_IMA_CLASS.PACKAGE_NAME,  MMR_IMA_CLASS.CLASS_NAME,  MMR_IMA_CLASS_ATTR.PRNT_CLASS_NAME,  MMR_IMA_CLASS_ATTR.CLASS_ATTR_NAME,  MMR_IMA_CLASS_ATTR.CLS_ATTR_DEFAULT_VALUE,  MMR_IMA_CLASS_ATTR.EDITABLE_FLAG  FROM  IMA_CLASS MMR_IMA_CLASS,  IMA_CLASS_ATTR MMR_IMA_CLASS_ATTR  WHERE  (MMR_IMA_CLASS.CLASS_UID = MMR_IMA_CLASS_ATTR.CLASS_UID)) "query"
where "ORIGINATOR_NAME" in ('<Originator_Name>') and "PACKAGE_NAME" in ('<Package_Name>') and "CLASS_NAME" in ('<Class_Name>')
order by "ORIGINATOR_NAME", "PACKAGE_NAME", "CLASS_NAME", "PRNT_CLASS_NAME", "CLASS_ATTR_NAME"

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