Informatica Workflow

An Informatica Workflow is a set of instructions that tells the Informatica integration services how to run one or more task which is connected by links. Every workflow will start with a Start task (by default). So, when you start the workflow, it will begin executing from the Start Task and continue until the tasks get finished. Informatica PowerCenter Workflow manager provides two approaches to create a workflow.

  • Creating Informatica Workflow manually
  • Creating Informatica Workflow using Wizard

In this article, we will show you how to create an Informatica Workflow manually with an example. To create a workflow, we need the task (Session or Email). For this example, we are going to use the already created session task.

Create Informatica Workflow

Before we start Informatica Workflow demo, First connect to Informatica repository service. To connect with the Repository service, we have to provide the Informatica Admin Console credentials. So, Please provide the appropriate Username and Password and click on the Connect button.

TIP: Please refer Session in Informatica article to understand the creation of session task and Reusable Session in Informatica article to understand the creation of reusable Informatica session task

From the below screenshot, you can observe that we are in the Task Developer.

Informatica Workflow 0

To create a new Informatica Workflow, first, we have to go to the Workflow Designer tab. Next, Please navigate to Workflows Menu and select the Create option.

TIP: Workflows Menu in the Menu bar will be available only when you are in the Workflow Designer section. Otherwise, it won’t show up.

Informatica Workflow 1

Once you select the Create option, a new window called Create Workflow will open Please provide the unique name, comments and You can leave the default settings

NOTE: Here you can change or delete the existing integration service also

Informatica Workflow 2

Once you created the Informatica workflow, you can create a Non-reusable session. Or you can use the already created reusable session. To demonstrate both, first, we are dragging the already created Reusable session s_DimProducts. Please refer to Reusable Session in Informatica article to understand the steps involved in creating this.

Informatica Workflow 4

Next, we removed the Reusable session and creating the New session task. Please refer to the Session in Informatica to understand the series of steps involved in creating the new session.

Informatica Workflow 4

Once you finished creating the Session task, we have link both the Start Task and Session Task. There are two ways to link them: First, you can select the Link Tasks button from the toolbar as shown below

Informatica Workflow 5

The second approach, Please go to Task Menu bar and select the Link Task option

Informatica Workflow 6

From the below screenshot, you can see the connection/link between the Start Task and Session Task.

Informatica Workflow 7

Once you finished creating the workflow in Informatica, we have to Validate the task before using it. To do so, Please navigate to Workflows Menu and select the Validate option.

Informatica Workflow 8

From the below screenshot, see that Our Informatica workflow is a valid one. Now, let us start the Informatica Workflow by navigating to the Workflows menu and selecting the Start Workflow option.

Informatica Workflow 9

Once you select the Start Workflow option, the Informatica PowerCenter Workflow monitor will be opened to monitor the workflow. From the below screenshot, you can observe that our workflow executed without any errors.

Informatica Workflow 10

Let us open the SQL Server Management Studio to check whether we successfully transferred the data from Adventure Works DW to the Informatica target database.

Informatica Workflow 11