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