In our previous tutorial, we discussed on workflow — which is nothing but a group of commands or instructions to the integration service. It defines how to run task like command task, session task, e-mail task, etc. To track everything is streamlined and executed in the desired order, we need a Workflow Monitor.
What is Workflow Monitor?
Workflow monitor is a tool with the help of which you can monitor the execution of workflows and task assigned to the workflow.
In workflow monitor you can,
- See the details of execution
- See the history of the workflow execution
- Stop, abort or restart workflows, and tasks
- Display the workflows those who are executed at least one time
In this Tutorial – you will learn
Workflow monitor consists of following windows –
- Navigator window- shows the monitored repositories, folders & integration service
- Output window – displays the messages from integration services and repository
- Properties window – displays the details/properties about tasks and workflows
- Time window – displays the progress of the running tasks & workflows with timing details.
Now, let see what we can do in Workflow Monitor
Step 1 – In Informatica Designer or Workflow manager toolbox, click on the workflow monitor icon
Step 2 – This will open workflow monitor window
In the workflow monitor tool, you will see the repositories and associated integration services on the left side. Under the status column, you will see whether you are connected or disconnected to integration service. If you are in the disconnected mode, you won’t see any running workflows. There is a time bar which helps us to determine how long it took a task to execute.
Step 3 – The workflow monitor is in a disconnected mode by default. To connect to integration service.
- Right click on the integration service
- Select connect option
After connecting, the monitor will show the status as connected.
Views in Workflow Monitor
There are two types of views available in Informatica workflow monitor
- Task view
- Gantt View
Task view displays the workflow runs in report format, and it is organized by workflow runs. It provides a convenient approach to compare workflow runs and filter details of workflow runs.
Task view shows the following details
- Workflow run list – Shows the list of workflow runs. It contains folder, workflow, worklet, and task names. It displays workflow runs in chronological order with the most recent run at the top. It displays folders and Integration Services alphabetically.
- Status message – Message from the Integration Service regarding the status of the task or workflow.
- Node – Node of the Integration Service executed the task.
- Start time – The time at which task or workflow started.
- Completion time – The time at which task or workflow completed the execution.
- Status – Shows status of the task or workflow, whether the workflow started, succeeded, failed or aborted.
In Gantt chart view, you can view chronological view of the workflow runs. Gantt chart displays the following information.
- Task name – Name of the task in the workflow
- Duration – The time taken to execute the task
- Status – The most recent status of the task or workflow
To switch between Gantt chart and task views
To switch from Gantt chart to Task view or vice versa, click on the respective button as shown in the screenshot to change the mode.
In previous examples, we have created a
- Mapping “m_emp_emp_target”: A mapping is a set of instructions on how to modify the data and processing of transformations that affects the record set.
- Session “s_ m_emp_emp_target” : A session is a higher level object to a mapping which specifies the properties of execution. For example performance tuning options, connection details of sources/targets, etc.
- Workflow “wkf_s_m_emp_emp_target”: A workflow is a container for the session and other objects, and it defines the timing of the execution of tasks and the dependency or flow of execution.
Now, we will analyze the details of execution in this topic.
Step 1 – Restart the workflow designer, as described in previous topic
Step 2 – Go to workflow monitor and in the monitor window you will see details as shown in screen shot like repository, workflow run details, node details, workflow run start time, workflow run completion time and status.
Step 3 – Here you can view the currently running workflow, which is having status as “running”.
Step 4 – Once the workflow execution completes, it status would change to succeeded/failed along with start and end time details.
Step 5 – To view the task details
- Right click on task name
- In the pop-up window select “get run properties”
A properties window would appear with the task details
Step 6 – Click on each of the menu of the properties window to view specific details.
Here we chose “Task Details” to view. It will display all the details like Instance Name, Task Type, Start Time, Integration Service Name, etc.
Task details –
Source and Target Statistics
Source and target statistics gives the details of source and target. For example, how many rows are fetched from the source and how many rows are populated in the target the current throughput, etc
In the following screen, 14 records are fetched from the source, and all 14 are populated in the target table.
- Applied rows signify how many records Informatica had tried to update or insert the target
- Affected rows signify how many numbers of applied rows were actually succeeded.Here all 14 rows are successfully loaded in the target, so the count is same for both.
- Rejected rows signify how many rows are dropped due to target constraint or other issues.
In this tutorial, you have learned how to open and monitor the workflows and tasks using workflow monitor.