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"