Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs
    • SQL FAQ’s

Informatica Workflow using Wizard

by suresh

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

Placed Under: Informatica

  • Download Informatica
  • Install Informatica
  • Informatica Admin Console
  • Informatica Repository
  • PowerCenter Designer
  • Informatica Workflow Manager
  • Informatica Workflow Monitor
  • Informatica ODBC Connection
  • Informatica Flat File Source
  • Move Data from SQL to another
  • Informatica Transformations
  • Aggregator Transformation
  • Expression Transformation
  • Informatica Java Transformation
  • Joiner Transformation – Normal
  • Informatica Master Outer Join
  • Informatica Detail Outer Join
  • Informatica Full Outer Join
  • Informatica Lookup
  • Informatica unconnected lookup
  • Normalizer Transformation
  • Informatica Rank with Group By
  • Router Transformation
  • Sorter Transformation
  • Sorter Trans- remove duplicates
  • Sequence Generator Transform
  • Source Qualifier Transformation
  • Informatica SQL Transformation
  • stored procedure transformation
  • Transaction Control Transform
  • Informatica Union Transformation
  • Update Strategy Transformation
  • Update Strategy in Informatica
  • Update Strategy using Session Properties
  • XML Generator Transformation
  • XML Parser Transformation
  • Informatica XML Source Qualifier
  • Informatica Pre SQL & Post SQL
  • Informatica Target Designer
  • Create Informatica Target Table
  • Create Target table using Source Definition
  • Informatica Mapping
  • Informatica Session
  • Informatica Reusable Session
  • Informatica Workflow
  • Create Workflow using Wizard
  • Informatica Command Task
  • Informatica Event Wait Task
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy