ODI Runtime Audit SQL
This sql works on an odi 11g environment. Useful for running sql against the audit tables to look at runtime, errors , rows effected when an odi interface has run. Run this SQL within the ODI Work Repository Schema.
select *
from
snp_session ss,
snp_sess_step,
snp_step_log
Where 1=1
and ss.sess_no = sss.sess_no
and sss.sess_no = ssl.sess_no
and ss.nno = ssl.nno
There’s some more reading and reference documetation below
See links below, some useful odi sql potentially to query operator audit information
https://community.oracle.com/thread/3587724?start=0&tstart=0
ODI Project Variables
Having defined a project variable, you can then refresh it, then use directly in an interface, I.e. If you created a variable VAR_CREATED_DATE which is refreshed via “select sysdate from dual” you could map it to a target column using this
to_date(substr(‘#VAR_CREATED_DATE’,0,19),’yyyy-mm-dd hh24:mi:ss’)