Informatica Audit Framework

Different name but the requirement or functionality is same:-


1) An ETL/Informatica Framework for Operational Metadata Logging

2) Process Control / Audit of Workflows in Informatica 

3) ETL Audit and Control information

4) A Scheduler framework for Audit – Balance and Control

5) Collecting Session Stat for audit purpose
below is the approach to implement the above requirement:-

The above requirement can be implemented using Informatica repository Views:-

The 2 vies used for this framework are:-
REP_SESS_LOG and REP_SESS_TBL_LOG one can find these view in the data base where Informatica repository server installed.

Let’s understand what blow query will do.  Both query’s will return last session run related records.

for example in the development Env we have 6 months of data in the views, out of that we will get only last run information for each session in a folder (as we are filtering data based on the folder first) **Where SUBJECT_AREA=PROJECT_FOLDER.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s