ABOUT INFORMATICA TRAINING

Informatica excels in Hybrid Integration. Several organizations rely on Informatica course training to obtain the potential to protect the information from devices to mobile to big data on-premise, in the Cloud, and over social networks.

objectives of informatica training:
  • Informatica Architecture
  • Designer interfaces and tools
  • Informatica Designer
  • Connected/Unconnected Transformations
  • Informatica – Workflow Manager
  • Working with Tasks
  • Informatica Advanced Features
  • Related Jobs and Positions in the Industry

Informatica online training covers all the concepts regarding integration of heterogeneous data sources and converting the raw data into useful information. This Informatica ETL tool enables a complete data integration solution and management system.

INFORMATICA – COURSE CONTENT

Introduction To Informatica
  • Overview with Basic Definitions
  • Informatica Products
  • Informatica Architecture
  • Tools and their roles
  • Folders -sub Folders
  • Power Centre I Power Malt
Informatica Designer – Introduction
  • Introduction to designer
  • Designer interfaces
  • Designer tools
  • Defining Sources
    – Database as a source
    – Rat Flies sources
  • Defining Targets
  • Importing from database
  • Creating a new target
  • Creating target database object
Informatica Designer – Advanced
  • Mapping Introduction
  • Source Qualifier
  • Ports
  • Mapping -Table to Table
  • Mapping flat File to Table
  • Connected/Unconnected Transformations
  • Active and Passive Transformation
  • Source Qualifier Transformation
  • SQl Override-Source Qualifier Transformation
  • Mapping Source Qualifier as Filter
  • Source qualifier to join Data
  • Filter Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Stored procedure Transformation (Connected & Unconnected)
  • Union Transformation
  • XMl Transformation
  • Mapping Wizards
  • Implementing Type-I, Type-II, Type-III and Mappings
Informatica – Workflow Manager
  • Workflow Introduction
  • Tasks
  • Workflow tools
  • Connections
Working With Tasks
  • Command Task
  • Email Task
  • Session Task
  • Link Conditions
  • Event Wait & Event Raise
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow
Informatica Advanced Features
  • Incremental Aggregation
  • Mapplet Implementation
  • Target Load Plan
  • Constraint based Loading
  • Mapping Parameters
  • Mapping Variables
  • Session parameters
  • Link Conditions