Informatica help

Informatica help and metadata report query

Element statistics

Informatica Element statistics

This Query provides the total number of elements for each class in the specified repository instance.


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


select "PACKAGE_NAME",
"ORIGINATOR_NAME",
"ELEMENT_UID",
"CLASS_NAME",
"CLASS_LABEL",
"REPO_TYPE_NAME",
"REPOSITORY_NAME"
from (SELECT  MMR_IMA_REPO_PACKAGE.REPO_TYPE_NAME,  MMR_IMA_ELEMENT.REPOSITORY_NAME,  MMR_IMA_CLASS.CLASS_LABEL,  MMR_IMA_CLASS.CLASS_NAME,  MMR_IMA_CLASS.PACKAGE_NAME,  MMR_IMA_CLASS.ORIGINATOR_NAME,  (COUNT(MMR_IMA_ELEMENT.ELEMENT_UID)) as ELEMENT_UID FROM  IMA_PACKAGE MMR_IMA_PACKAGE,  IMA_REPO_PACKAGE MMR_IMA_REPO_PACKAGE,  IMA_ELEMENT MMR_IMA_ELEMENT    RIGHT OUTER JOIN IMA_CLASS MMR_IMA_CLASS    ON MMR_IMA_ELEMENT.CLASS_ID = MMR_IMA_CLASS.CLASS_ID  WHERE  (MMR_IMA_CLASS.PACKAGE_UID = MMR_IMA_PACKAGE.PACKAGE_UID AND  MMR_IMA_REPO_PACKAGE.PACKAGE_UID = MMR_IMA_PACKAGE.PACKAGE_UID)  GROUP BY  MMR_IMA_REPO_PACKAGE.REPO_TYPE_NAME,  MMR_IMA_ELEMENT.REPOSITORY_NAME,  MMR_IMA_CLASS.CLASS_LABEL,  MMR_IMA_CLASS.CLASS_NAME,  MMR_IMA_CLASS.PACKAGE_NAME,  MMR_IMA_CLASS.ORIGINATOR_NAME  HAVING  (COUNT(MMR_IMA_ELEMENT.ELEMENT_UID)) > 0) "query"
where "REPO_TYPE_NAME" in ('<Repository_Type_Name>') and "REPOSITORY_NAME" in ('<Repository_Name>')
order by "REPO_TYPE_NAME", "REPOSITORY_NAME"

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