ODI is the one of the most common ETL tool , especially in Turkey. It is very user friendly , easy to learn , tons of docs at web and there are many other advantages.
Some times when we make a technical analysis about our ETL processes. And we need to find an ODI scenario that includes our table as a source or as a target. We can check our scenarios manually but when it is Oracle , there are always easier ways.
We can use this script for find which scenario log has our tables name in it.
SELECT sess_beg, sess_name FROM snp_session where 1=1 --AND to_char(sess_beg,'YYYYMMDD')='20191101' AND sess_beg >TRUNC(SYSDATE-2) AND sess_no in (select distinct sess_no from SNP_SESS_TASK_LOG where upper(def_txt) like '%<<YOUR_TABLE_NAME>>%') ORDER BY sess_beg ;
There is one little rule for using this script successfully , scenario must run at least one time. That is a must , because we are using the log that generated by ODI. So it must be generated.
You can download ODI demo VM that link below ;