Auditing Tables in Informatica -
we want maintain auditing of tables , question 1)will commit interval in informatica stored anywhere in variable , can maintain record count every commit interval.
2)is there method/script read stats session log , save in audit table.
3)if there multiple targets in mapping in monitor after executing show target success count , target reject count total targets in mapping. how individual target success , reject count .
you need use informatica metadata tables informatica doesn't recommend(still mentioning reference). options create sh/bat script these info session log or create maplet collects kind of statistics , add maplet in every infa mappings. answers questions -
- yes, commit intervals stored in informatica table opb_task_attr attr_id=14 , select attr_value.
- nope, either can use infa mapplet collct such stats or shell script.
- yes possible. use infomatica view rep_sess_tbl_log purpose. here can each target's statistics of particular session's run.
koushik
Comments
Post a Comment