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 -

  1. yes, commit intervals stored in informatica table opb_task_attr attr_id=14 , select attr_value.
  2. nope, either can use infa mapplet collct such stats or shell script.
  3. yes possible. use infomatica view rep_sess_tbl_log purpose. here can each target's statistics of particular session's run.

koushik


Comments

Popular posts from this blog

basic authentication with http post params android -

vb.net - Virtual Keyboard commands -

css - Firefox for ubuntu renders wrong colors -