Informatica Workflow using Wizard

In this article, we will show you how to create Informatica Workflow using Wizard with an example. Please refer Informatica Workflow article to understand the steps involved in creating Informatica Workflow manually

Creating Informatica Workflow using Wizard

Before we start creating Informatica Workflow using Wizard, First connect to Informatica repository service using the Informatica Admin Console credentials.

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

Informatica Workflow using Wizard 1

Select the Wizard option opens a new window called Workflow Wizard. Please provide a unique name, description and select the Integration service from the drop-down list

Informatica Workflow using Wizard 2

Within Step 2, we have to select the mapping from the Select the Mappings section.

From the following screenshot, we have only one mapping. So we are selecting it. Once you chose the Mapping click on the >> button to create the session for the selected mapping

TIP: Please refer Informatica Mapping article to understand the data transformation in below mapping m_DimProducts_from_SQL_to_SQL

Informatica Workflow using Wizard 3

Once you click on the >> button, the session task created automatically. By check-marking, the Reusable option will make this session as a reusable session task.

Informatica Workflow using Wizard 4

Within Step 2, we have to schedule the workflow. Here we have three Run options:

  • Run On Demand: You have to start the workflow as per your requirements.
  • Run Continuously: Workflow will run continuously.
Informatica Workflow using Wizard 5

Next,

Run On Integration Service: Here, you have an option to schedule the workflow. For instance, if you want to load data from text file to SQL Database every Monday, then you schedule the workflow on Monday 1 AM

Informatica Workflow using Wizard 6

Before we click on the finish button, check the details. If you find any issues, click the Back button to alter the workflow.

Informatica Workflow using Wizard 7

From the below screenshot you can see the new workflow

Informatica Workflow using Wizard 8

Once you finished creating the Informatica Workflow using Wizard, we have to Validate the task. For this, navigate to Workflows Menu -> Validate option.

Informatica Workflow using Wizard 10

From the below screenshot, you can see that Our Informatica workflow is a valid one.

Informatica Workflow using Wizard 9

Let us start the Informatica Workflow by selecting the Start Workflow option.

Informatica Workflow using Wizard 11

Once you select the Start Workflow option, Informatica PowerCenter Workflow monitor opens to monitor the workflow. As you can see, the workflow executed without any errors.

Informatica Workflow using Wizard 12

Let us open the SQL Management Studio to check whether we successfully transferred the data from AdventureWorksDW to the target SQL Server database.

Informatica Workflow using Wizard 13