Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Operator (ODI)

ODI Operator lets you to monitor the execution log.

It is similar to Informatica Workflow monitor.  However, the logs are stored in the database.  (SNP_SESSION, SNP_SESS_STEP, SNP_SESS_STEP)

It show you the sessions, session steps, and session tasks in a tree like structure in the Operator.

When we use Informatica, we typically look at the log files from the directory that Informatica integration service is installed.  Informatica has the workflow log file and the workflow session log file.   We open the files and look at those files in a text editor.  We use the desktop sharing to get the access to those files.

When we use ODI, we can query the data from the work repository to get the access to the execution log.