Informatica Training

User Avatar

Informatica Training is the world leader in Enterprise Cloud Data Management, and forsee a generational market disruption in data is underway. We are entering Data 3.0, where data powers digital transformation, and we’re prepared to help you intelligently lead in any sector, category or niche. Informatica provides you with the foresight to become more agile, realize new growth opportunities, and create new inventions.

With 100 percent focus on everything data, we offer the versatility needed to succeed. We invite you to explore all that Informatica has to offer—and unleash the power of data to drive your next intelligent disruption.

Target Audience

  • BI Professionals
  • Mainframe and database Professionals
  • Project Managers
  • ETL & SQL Developers

Course objective

Informatica Training Course objective

  • Informatica architecture and PowerCenter
  • Informatica installation and configuration
  • Informatica workflow monitoring and managing
  • Jobs and Tasks handled by power centers
  • workflow variables and session parameters
  • Informatica Admin Console
  • performance tuning of Informatica
  • Managing Informatica Repository
  • ETL functionalities and scenarios
  • Informatica SQL and XML transformation

Course content


  • Data Warehousing and Cleansing Concepts
  • Informatica Installation and Configuration
  • Working with an active and passive transformation
  • Working with expression transformation
  • Working with Sorter, Sequence Generator, Filter transformation
  • Working with Joiner Transformation
  • Working with Ranking and Union Transformation
  • The syntax for Rank and Dense Rank
  • Router Transformation
  • Source Qualifier Transformation and Mappings
  • Slowly Changing Dimension in Informatica
  • Mapplet and loading to multiple designers
  • Performance Tuning in Informatica
  • Repository Manager
  • Best Practices in Informatica
  • Workflow Informatica
  • Parameters & Variables
  • Error handling and recovery in Informatica
  • 11111High Availability & Failover in Informatica
  • Working with different utilities in Informatica
  • Flatfile processing (advance transformations)
  • Dynamic targeting
  • Working with Java transformations
  • Unconnected Stored Procedure usage
  • Advanced Concepts in SCD
  • Incremental Data Loading and Aggregation
  • Constraint-based loading
  • XML Transformation and active lookup
  • Profiling in PowerCenter
  • Workflow Creation and Deletion
  • Database Connection
  • Relational Database Tables
  • LinkedIn Connection
  • Connection with Sources
  • Push down optimization & Partitioning
  • Cache management

Course Features

  • Lectures 0
  • Quizzes 0
  • Duration 50 hours
  • Skill level All levels
  • Language English
  • Students 0
  • Assessments Yes

You have 10 weeks remaining for the course

Curriculum is empty

Leave A Reply

Your email address will not be published. Required fields are marked *