[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


Quering Informatica Repository/Oracle

Published on
6,700 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

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Join & Write a Comment

This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month