Populating OBIEE Event Polling Table via Trigger

When using Oracle BI Applications there is often the need to invalidate OBIEE’s query cache once new data has been loaded into the Data Warehouse to prevent users from seeing stale data in the reports. Perhaps the simplest and most elegant method to do this is to make use of the standard Event Polling Table […]

Informatica: Impacted Sessions Error

I came across an interesting error when trying to run a customised Informatica Workflow. It failed and this message appeared in the log file: “The Repository Service marked the session or session instance as impacted, and the Integration Service is not configured to run impacted sessions” It seems that the Session called by the Workflow […]

Get Informatica Node Name

Further to my earlier post where I queried the metadata schema to get various Informatica parameters, I thought I would share this quick snippet… In order to get the Informatica Node name you can run this shell command (Unix): ${INFA_HOME}/isp/bin/infacmd.sh getNodeName | grep -e \n -m 1 Bye for now…

Get Informatica 9.x Domain Details from Metadata

When setting up Informatica Client tools you might get stuck wondering what settings to use for the Domain and Port number. Presumably you will know the machine host name to use. You can use some sql against the Informatica metadata tables to help you figure out the required settings. E.g. something like this: SELECT RINF.PCSF_DOMAIN […]

Oracle Business Intelligence Applications 7.9.6.2 Available

BI Apps 7.9.6.2 is available to download from Oracle right now. I haven’t had a chance to evaluate this yet but I’m looking forward to having a play and in particular trying out the supposed tighter integration with Informatica PowerCenter 8.6.1. You can read more detail in the official Oracle Press Release.