Quering Informatica Repository/Oracle

Published on
6,609 Points
Last Modified:
A little bit more into the woods of Informatica Repository,
things get grimmer:)

But don't be afraid ,You've set-up dblinks and You can query the repository,now what do You query to find failed sessions:
2 options :


INFORMATICA.REP_SESS_LOGs,I prefer 1-st ,has full info:

Finally,after You're done with logging,You need a little bit coding to fetch the info and may be assemble it for a report but finally You can get something very nice with little effort(take a look at the chart bellow)

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Join & Write a Comment

This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month