Informatica Online Training  Ameerpet Hyderabad

  • Overview Basic Definitions
  • Informatica Products, Architecture
  • Tools and their Roles
  • Understanding Informatica Server Configuration
  • Informatica Online Training Ameerpet Hyderabad
  • Informatica Designer

  • Basic Concepts
  • Using the Designer
  • Working with Sources
  • Working with Flat Files, Targets
  • Mappings, Transformations, Mapplets
  • Working with Debugger
  •  Implementing Type 1, Type2, Type 3 Mappings
  • Loading the data into different fact  tables
  • Using the designerTransformation Creation
    • Creating Source Tables.
    • Creating Target Definitions.
    • Creating Target Tables
    • Creating a Pass-Through Mapping
    • Creating source definitions
    • Creating a Mapping
    • Connecting Transformations
    • Using Transformations
    • Creating a Mapping with Aggregate Values
    • Active and passive transformations
    • Creating an Aggregator Transformation
    • Creating an Expression Transformation
    • Creating a Lookup Transformation
    • Connecting the Target
    • Designer Tips.
    • Using the Overview Window
    • Arranging Transformations
    • Creating the Session
    • Creating the Workflow
    • Creating a Mapping with Fact and Dimension Tables
    • Creating a Filter Transformation
    • Creating a Sequence Generator Transformation
    • Creating a Stored Procedure Transformation
    • Completing the Mapping
    • Creating a Workflow
    • Creating a Link Condition.
    • Running the Workflow

Working with Transformations

  • Aggregator Transformation
  • XML Transformation
  • Expression, Look up Transformation
  • Rank, Router, Filter, Sequence Generator
  • Sorter Transformation
  • Source Qualifier Transformation
  • Stored Procedure Transformation
  • Transaction Control Transformation
  • Joiner, Union Transformation
  • Java Transformation
  • SQL Transformation
  • XML Source Qualifier
  • XML Generator
  • XML Parser
  • Update Strategy Transformation
  • Mapplet Input Transformation
  • Mapplet Output Transformation
  • Connected Vs Unconnected Transformations

Creating Work flows

  1. Understanding the server Architecture
  2. Working with Workflows
  3. Working with Tasks like Assignment , Command, Decision Control, Event Raise, Event Wait, Timer , Email, Session Task
  4. Working with Worklets
  5. Working with Sessions
  6. Understanding Commit Points
  7. Monitoring Workflows
    1. Session Parameters
    2. Parameter files
    3. Using Incremental Aggregation
  8. Real-Time Implementation with Informatica
    • Using Incremental Aggregation
    • Incremental Extraction with Mapping Parameters and Variables
    • Session parameters and variables
    • Session and Workflow Properties Reference
    • Configuring Session Caches Lookup, Aggregate, Sort, Joiner Caches
    • Constraint Based Loading
    • Target Load Plans
    • Dynamic Lookup
    • Informatica Online Training Ameerpet Hyderabad

1.Unconnected lookup Transformation
2.Unconnected Stored Procedure to Create and Drop Index
3.Mapplet and Types of Mapplets
4.Defining Reusable Transformations.
5.User Defined Functions
6.Tasks And Types of Tasks
7.Worklet and Types of Worklets
8.Scheduling Work flow
9.Constraint Based Load Ordering
10.Target Load Plan
11.Types of Batch Processing
12.Link conditions
13.Mapping Parameters
14.Mapping Variables
15.Defining Session Parameters
16.Session Recovery
17.Difference Between Normal and Bulk Loading
18.Push Down Optimization
19.PMCMD Utility
20.PMREP Utility
21.Incremental Aggregation


Find out if YOU are a candidate

IELTS Coaching

IELTS Coaching



Imigration to Canada

Imigration to Canada

Visa Guidance

Visa Guidance


Our promoters being passionate, experienced, and dedicated academicians with immense exposure of more than 25 years in India and Canada can help potential aspirants realise their dreams of settling in Canada.

Being a Canadian resident, our chairman has been associated with the Canadian Ministry of Education, Universities and Colleges of Canada for the past 13 years.

Read More >


  • Students Study Visa
  • Visitors Visa guidance
  • IELTS Coaching
  • IT Training
  • Financial Assistance
  • Employability Skills Training
  • Campus Recruiting Training


i2C Education & Immigration
#410, Nilgiri Block, Aditya Enclave, Ameerpet, Hyderabad - 500038,

040 4852 7978, +99 1212 0040, 99 1212 0050

+1 416 495 6922, +1 647 961 6047