Informatica Advanced Course

leading provider of enterprise data integration software

Informatica Advanced Online Training

CSRCIND Provides Informatica Advanced Online Training Informatica's product is a portfolio focused on Data Integration: ETL, Information Lifecycle Management, B2B Data Exchange, Cloud Data Integration, Complex Event Processing, Data Masking, Data Quality, Data Replication, Data Virtualization, Master Data Management, Ultra Messaging; currently at version 9.6 These components form a toolset for establishing and maintaining enterprise-wide data warehouses. It has a customer base of over 5,000 companies.

What you will learn

Informatica is a widely used ETL tool for extracting the source data and loading it into the target after applying the required transformation,Informatica enables organizations to gain a competitive advantage in today’s global information economy by empowering companies with timely,relevant and trustworthy data for their top business imperatives.

  • Informatica Concepts and Overview
  • Power Center Tools
  • Basic Concepts and Components

Informatica Advanced Online Training Course Content


  • Informatica Concepts and Overview
  • Data Warehousing concepts
  • ETL Concepts.
  • Informatica Architecture
  • Power Center Tools
  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
    Basic Concepts and Components
  • Source Qualifier
  • Target Designer
  • Transformations
  • Mappings
  • Mapplets
  • Sessions
  • Tasks
  • Sources
  • Working with relational Sources
  • Working with Flat Files
  • Targets
  • Working with Relational Targets
  • Working with Flat file Targets
  • Transformations
  • Expression Transformation
  • Lookup Transformation
  • Sequence Generator Transformation
  • Filter Transformation
  • Joiner Transformation
  • Sorter Transformation
  • Router Transformation
  • Aggregator Transformation
  • Update Strategy Transformation
  • Union Transformation
  • Rank Transformation
  • Transaction Control Transformation
  • Normalizer Transformation
  • Source Qualifier Transformation
  • Stored Procedure Transformation
  • XML Source Qualifier Transformation
  • Debugging Mappings
  • Advanced Informatica Concepts
  • Unconnected lookup Transformation
  • Mapping Parameters
  • Mapping Variables
  • Target Load Plan
  • Defining Reusable Transformations.
  • Mapplets
  • Tasks And Types of Tasks.
  • Worklet
  • Scheduling Workflow
  • Types of Batch Processing
  • Link conditions
  • Defining Session Parameters
  • PMCMD Utility


  • Types Of Lookup Caches
  • Static LookUp Cache
  • Dynamic LookUp Cache
  • Perisistance lookup Cache
  • Shared LookUp Cache
  • Task Types:
  • Session
  • Command
  • Worklet
  • Timer
  • Event Wait
  • Event Raise
  • Decision
  • Control
  • Informatica Architecture and components
  • Domain , Node,Master Gateway Node
  • Services (Integration Service,Repository Service,DIS,CMS,MRS etc)
  • Administrator Tool Overview, User,Role Group creation.
  • Performance Tuning
  • Approach and Concepts
  • Partitioning,Dynamic Partitioning
  • Ways to handle different bottlenecks with example
  • Push Down optimization
  • Types of PDO
  • Transformations supported
  • What are views created for PDO etc
  • ETL Auditing
  • Whats is ETL auditing and need of it
  • Different ways of ETL auditing (PMERROR tables, Pmcmd commands,Repository queries etc)
  • Automation using Informatica PC
  • PMCMD command usage
  • XML generation
  • Incremental aggregation
  • Concurrent Workflows
  • Workflow Recovery
  • External Loading

Informatica News

  • Informatica : The Information Difference Recognizes Informatica as a Technology and Market Leader in MDM

    Courtesy :
    (GlobeNewswire) - Informatica Corporation (Nasdaq:INFA), the world's number one independent provider of data integration software, today announced that More

Back to top