top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Export details of workflow from Informatica Powercenter Monitor

0 votes
739 views

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.
posted Jul 3, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
Hi

Same problem I am facing. If u did it automated, did u like to share with me?
Very old thread, may be post a new query...

1 Answer

0 votes

The repository database provides a set of views called Metadata Exchange (MX) Views that allow SQL access to the metadata. The information you need can be found in REP_SESS_LOG and REP_SESS_TBL_LOG. You will find a detailed description of these views in the Repository Guide - you can find it in the Informatica installation directory on your server or download from Informatica My Support site (you need to be a registered user).

answer Jul 10, 2014 by Shweta Singh
Similar Questions
+2 votes

Is there any environment variable which holds the value of task ran ?

+1 vote

What is the difference between STOP and ABORT options in Workflow Monitor?

0 votes

I have a stored procedure being called from an informatica mapping. There are no manual commits inside the procedure and the procedure is created with 'COMMIT ON RETURN NO'

I can see the updates done inside the procedure being committed. I think this could be because of the auto commit setting in the Informatica Server. (And I assume the 'commit after end of file' option in the task properties does not apply to stored proc calls)

If this is the case,assuming I do not want to commit anything even if procedure completes without errors, where do I find the autocommit setting (BD2 Driver configuration/Informatica configuration) and change it?

0 votes

Teradata : JANUVIA - 50MG – TABLET - 1 BLISTER - 28 TABLET (28.TA) ORacle: JANUVIA - 50MG ? TABLET - 1 BLISTER - 28 TABLET (28.TA)

We are using code page 'ms windows latin 1 (ansi) superset of latin1' for source connection i.e. Teradata.

We are using code page UTF 8 for target

+2 votes

I have two sessions I a workflow like below

workflow1->session1->session2

I have a join_date column in a table in Mapping1 , in session1. I want to pick this join_date value and pass to mpping2/session2

If join date value changes in the table in session1 then the same value should pick and pass to session2. I will use this date value in a query in session2 .

Please suggest how to achieve this?

...