Informatica Workflow using Wizard

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

• Creating Informatica Workflow manually
• Creating Informatica Workflow using Wizard

In this article we will show you, How to create Informatica Workflow using Wizard with 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. In order to connect with Repository service we have to provide the Informatica Admin Console credentials so, Please provide the appropriate Username and Password and click on Connect button as shown below.

In order to create new Informatica Workflow, first we have to go to the Workflow Designer tab. From the below screenshot you can observe that, we are in the Workflow Designer. Next, Please navigate to Workflows Menu and select the Wizard option as shown below.

TIP: Workflows Menu in the Menu bar will be available only when you are in Workflow Designer section otherwise, it will be hidden.

Once you select the Wizard option, a new window called Workflow Wizard will be opened as shown below. Please provide the unique name, Description and select the Integration service from drop down list

Within the Step 2 we have to select the mapping from the Select the Mappings section. From the below screenshot you can observe that, currently we have only one mapping so we are selecting it. Once you selected 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 specified mapping  m_DimProducts_from_SQL_to_SQL

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

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

• Run On Demand: If you select this option then you have to start the workflow as per your requirements.
• Run Continuously: If you select this option, Workflow will run continuously.

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

Before we click on finish button, Please check the details and if you find any issues then click Back button to alter the workflow.

From the below screenshot you can see the new workflow

Once you finished creating the informatica Workflow using Wizard, we have to Validate the task before using it. In order to do so, Please navigate to Workflows Menu and select the Validate option as shown below.

From the below screenshot you can observe that, Our informatica workflow is a valid one.

Now, Let us start the Informatica Workflow by navigating to Workflows menu and selecting the Start Workflow option.

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

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.

Thank You for visiting Our Blog