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.
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