Pages

Search This Blog

Sunday, October 25, 2015

[informatica] Get stats/statistics mantained by Informatica

So below are few queries which would help you to get the statistics which is saved by Informatica into its repository and the one which is available in Informatica monitor to view:

1. From the below query, you can take up workflow information. Also workflow run id is important, if you need to see more detailed info from other tables:

select* from dbo.OPB_WFLOW_RUN

where WORKFLOW_NAME='wf_'

order by workflow_run_id;

2. From the below query, you can take up session information, like session start time and other details, but it wont show you the row counts that moved.

select *

from dbo.REP_TASK_INST_RUN

where subject_area='INTG_'

and WORKFLOW_NAME='wf_'

and workflow_run_id=2574343;

3. From the below query, you can take up other session details, like how much rows were moved etc.

select * from
OPB_SESS_TASK_LOG where workflow_run_id=2574343;
 

Wednesday, October 7, 2015

[scripting] Alternate for touch command in Windows for Unix

I was working on a requirement where I need to process Informatica workflow from a source file. But the issue was that file might exist and in some case it might get missing. So was searching for replacement of touch command in unix and here is the code:

$PMSourceFileDir\$$SOURCE_FILENAME --- is your file path

type nul >>$PMSourceFileDir\$$SOURCE_FILENAME & copy $PMSourceFileDir\$$SOURCE_FILENAME +,,