This content has been marked as final. Show 7 replies
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.
Then put these substution api in the body part f odisendmail , just after your interface . This will capture the log information.
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 holds1 person found this helpful
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.
All these tables are held in the ODI Work Repostiory.. You will need to connect to this and query the tables