Informatica help

Informatica help and metadata report query

Repository Instances

Informatica Repository Instances

This query will get you a list of Repository Instances


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


select "EXTENDABLE_FLAG",
"PACKAGE_NAME",
"CLASS_DESC",
"ORIGINATOR_NAME",
"MODIFIED_ON",
"CLASS_NAME"
from (SELECT  DISTINCT MMR_IMA_CLASS.ORIGINATOR_NAME,  MMR_IMA_CLASS.PACKAGE_NAME,  MMR_IMA_CLASS.ORIGINATOR_ID,  MMR_IMA_CLASS.PACKAGE_ID,  MMR_IMA_CLASS.CLASS_ID,  MMR_IMA_CLASS.CLASS_NAME,  MMR_IMA_CLASS.CLASS_DESC,  CONVERT(VARCHAR,MMR_IMA_CLASS.MODIFIED_ON,23) as MODIFIED_ON,  MMR_IMA_CLASS.EXTENDABLE_FLAG  FROM  IMA_CLASS MMR_IMA_CLASS) "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", "CLASS_DESC", "MODIFIED_ON", "EXTENDABLE_FLAG"

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