I am new to informatica. Whenever we run any workflow its details are shown in the monitor. Everyday I need to prepare an excel report of those details manually.
I want to automate this process.
For this job I wanted to know in which file details of the workflow run are stored which are displyed by Informatica monitor. So that I can build a program which will read that file interprete the values and will create an Excel report automatically avoiding my Manual work.
Modification - By details of Workflow I mean...
The number of records which were provided as input to interface.
The number of records which were successfully processed and sent to target table.
The number of records which were rejected during the process.
The number of records which went into Exception table.