Please let me know how to export / extract required information from execution log from Operator.
To breif, If I want to know execution time , records inserted,updated,deleted from specific time, Is there any tool or option availble in ODI .
Thanks in Advance,
yes you can. you can insert them into an audit table or you can use them in odi send mail to send the details via mail.
Depends on your customization.
The basic codes required are given below.
We dont use customized audit table so is there any option which will give below number using ODI's table
1.total number of inserts/update/delete in target table only and not intermediate tables (if any)
2.total number of errors in E$ tables.
3.and duration at package level.
Thanks in Advance.
But I am keen to know/use any ODI table where I could get this information like SNP_SESSION, where I can query from database and get the report without changing ODI package.
The SNP_SESSION able holds the bulk of the data you are looking for. In terms of the errror row information you will need to query the SNP_CHECK_TAB table which is created when static/flow control is enabled, by default, this table will be created in the work schema of your default physical schema of your DB data server. Take a look at this helpful blog with lots more information on this table and the information it holds
At least I could get total number of errors.
But Can anyone tell where can I find SNP_SESSION , snp_step_log, snp_sess_task_log tables.
As I tried to query on this table on target as well as work schema, I can not find those.
Thanks in advance.