Informatica Introduction Workflow
Posted by Superadmin on December 11 2018 05:38:12

 

Informatica Workflow Manager

 

 

The Informatica Workflow Manager is used to create a Workflow. A workflow is nothing but a set of instructions to execute the Mappings that we designed in the PowerCenter Designer. Generally, a workflow contains a Session Task, Command Task, Event Wait Task, Email Task etc. It also helps you to schedule the Mappings.

 

Informatica PowerCenter Workflow Manager has an import option called Worklet designer, Which is used to combine (group) one or more task to make a Powerful task. 

Informatica Workflow Manager

In order to open the Informatica Workflow Manager, Please Go to the Start menu -> All Programs -> Informatica -> PowerCenter Workflow Manager. Once you click on that, following window will be opened.

Before we start designing we have to connect with the Repository Service so, Please select and Right Click the PowerCenter Repository Service (INF_Repository) under the repository section and select the Connect option

 

Informatica Workflow Manager 1

In order to connect with the PowerCenter Repository service we have to provide the Informatica Admin Console credentials so, Please provide the Username and Password.

TIP: Here you have to provide the Admin Username and password that you specified while installing the Informatica Server.  

 

Informatica Workflow Manager 2

Once you connected successfully, the following window is displayed. If you observe the below screenshot, you can see the folders. In order to see the existing Tasks, Worklets, and Workflows or to create them please right-click on the folder and select Open from Context menu.

Informatica Workflow Manager 3

Clicking the Open will show the following window. The following screenshot will show the list of available tools inside the Informatica Workflow Manager.

  1. Navigator: This section is will allow us to connect with the Informatica Repository services and navigate between Different Folders such as Tasks, Sessions, Worklets, and Workflows.
  2. Work space: Use this section to create Tasks, Sessions, and Workflows.
  3. Output window: In this section, You can check whether the Task or Workflow is Valid or not. To find the Errors.
  4. Task Developer: This allows us to create Tasks such as Session Task, Email Task etc.
  5. Worklet Designer: This allows us to create Worklets
  6. Workflow Designer: Using this designer you can create a workflow by connecting the tasks. We already explained the Workflows in our previous article.

Informatica Workflow Manager 4

Expand the Workflows folder to see the existing Workflows

Informatica Workflow Manager 5

In order to work with any of the workflow, Sessions, Tasks, Worklets, right-click on it and select the Open from the context menu.

Informatica Workflow Manager 6

 

 

 

 

Informatica Workflow Monitor

  

The Informatica Workflow Monitor is used to monitor the execution of Workflows or task assigned in the Workflow. Generally, Informatica PowerCenter helps you to track the Event Log information, list of executed Workflows, and their execution time in detail.

 

Informatica Workflow Monitor

In order to open the Informatica Workflow Monitor, Please Go to the Start menu -> All Programs -> Informatica -> PowerCenter Workflow Monitor. Once you click on that, following window will be opened. 

From the below screenshot you can observe that We divided the Informatica PowerCenter Workflow Monitor screen into four sections to explain each section in details. Let us see them individually,

  1. Navigator: This section will allow us to connect with the Informatica Repository services and navigate between Different Workflows.
  2. Workflow Run: This section helps you to monitor the Workflow execution
  3. Output window: In this section, You can see the steps that we performed in this Workflow Monitor.
  4. Properties Window: It will display the information about the current operation.

Informatica Workflow Monitor 1

 

Before we start anything we have to connect with the Repository Service. So, Please select and Right Click the PowerCenter Repository Service (INF_Repository) under the repository section and select the Connect option

Informatica Workflow Monitor 2

In order to connect with the PowerCenter Repository service, we have to provide the Informatica Admin Console credentials. So, Please provide the Username and Password. 

 

TIP: Here you have to provide the Admin Username and password that you specified while installing the Informatica Server.

Informatica Workflow Monitor 3

Once you connected successfully, the following window will be displayed. If you observe the below screenshot, you can see the Integration Service. In order to see the existing Workflows, please right-click on the Integration Service and select Open from Context menu.

Informatica Workflow Monitor 4

Now you can see the folders. In order to see the existing Workflows or to run them please right-click on the folder and select Open from Context menu.

Informatica Workflow Monitor 5

Expand the individual Workflows to see the previous execution details i.e., Workflow Run start Time, Completion Time, and the Status of the run.

Informatica Workflow Monitor 6

Informatica Workflow Monitor provides Gantt Chart to see the execution in detail. In order to see, right-click on Workflow and select the Go to Gantt Chart from the context menu.

Informatica Workflow Monitor 7

Now you can see the Workflow run in Gantt Chart

Informatica Workflow Monitor 8

By simply selecting the Workflow you can see the information in the properties window

Informatica Workflow Monitor 9

Let me remove the Output window to explore the Properties window information. Next, we are running the Event Wait Task workflow to show the Workflow run. From the below screenshot you can observe, Under the Task details tab you can see the all the information about the task

Informatica Workflow Monitor 10

Under the Source or Target Statistics, you can see the Rows flow. I mean, the number of rows passed, failed etc.

Informatica Workflow Monitor 11

Under the partition tab, you can see the partition information (if any). And use the Performance tab to check the performance of any task

Informatica Workflow Monitor 12

In order to see the details Event log of any task, right-click on the Task and select the Get Session Log from the context menu.

Informatica Workflow Monitor 13

You can see the detailed Event log. Generally, we used this Session log to check the error position. I mean, at what position error was thrown and the reason for it.

Informatica Workflow Monitor 14