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 manually with example. In order to create a workflow we need the task (Session or Email). For this example we are going to use the already created session task.
Creating Informatica Workflow
Before we start doing anything, 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. From the below screenshot you can observe that, we are in the Task Developer.
In order to create new Informatica Workflow, first we have to go to the Workflow Designer tab. Next, Please navigate to Workflows Menu and select the Create 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 Create option, a new window called Create Workflow will be opened as shown below. Please provide the unique name, comments and You can leave the default settings as it is
NOTE: Here you can change or delete the existing integration service also
Once you created the informatica workflow, you can create 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 Reusable session in Informatica article to understand the steps involved in created this.
Next, we removed the Reusable session and creating the New session task. Please refer the Session in Informatica to understand the series of steps involved in creating the new session.
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
Second approach, Please go to Task Menu bar and select the Link Task option as shown below
From the below screenshot you can see the connection / link between the Start Task and Session Task.
Once you finished creating the workflow, 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