Tech Monger

Informatica stores basic workflow details inside repository view REP_WORKFLOWS. These details can come handy when you want to know information about workflow like when was workflow been last modified or current version of workflow. Below are the some of the useful columns from view REP_WORKFLOWS.

REP_WORKFLOWS

WORKFLOW_ID

WORKFLOW_NAME

SUBJECT_AREA

SERVER_NAME

WORKFLOW_LAST_SAVED

WORKFLOW_VERSION_NUMBER

WORKFLOW_IS_VALID

WORKFLOW_IS_IMPACTED

Informatica Basic Workflow Information Queries

List of all workflows from specific folder

SELECT SUBJECT_AREA, WORKFLOW_NAME
FROM REP_WORKFLOWS
WHERE SUBJECT_AREA='Folder Name';

List of all workflows configured to run under specific Integration Service

SELECT WORKFLOW_NAME, SERVER_NAME
FROM REP_WORKFLOWS
WHERE SERVER_NAME='INT_SERVICE_NAME';

Workflows last saved between specific dates

SELECT SUBJECT_AREA, WORKFLOW_NAME, WORKFLOW_LAST_SAVED
FROM REP_WORKFLOWS
WHERE TRUNC(TO_DATE(WORKFLOW_LAST_SAVED, 'mm/dd/yyyy HH24:MI:SS'))
BETWEEN TO_DATE('01/JAN/2017','dd/mon/yyyy') AND
TO_DATE('31/MAR/2017','dd/mon/yyyy');

Find the current version number of a workflow

SELECT WORKFLOW_NAME, WORKFLOW_LAST_SAVED, WORKFLOW_VERSION_NUMBER
FROM REP_WORKFLOWS
WHERE WORKFLOW_NAME='WORKFLOW-NAME';

Find all impacted workflows due to changes done in dependent objects of workflow

SELECT SUBJECT_AREA, WORKFLOW_NAME, WORKFLOW_IS_IMPACTED
FROM REP_WORKFLOWS
WHERE WORKFLOW_IS_IMPACTED = 1
ORDER BY SUBJECT_AREA;

Find list of all invalid workflows from specific folder

SELECT SUBJECT_AREA, WORKFLOW_NAME, WORKFLOW_IS_VALID,WORKFLOW_VERSION_NUMBER
FROM REP_WORKFLOWS
WHERE WORKFLOW_IS_VALID = 0 AND
SUBJECT_AREA = 'FOLDER-NAME'
ORDER BY WORKFLOW_NAME;

Conclusion