• Welcome to CloudMonks
  • +91 96660 64406
  • info@thecloudmonks.com

Informatica PowerCenter Online Training

About The Course

Cloudmonks Informatica Online Training helps you to know how the Informatica PowerCenter tool helps to scale high performance to develop data integration solutions through live experts. Learn Informatica Online Training from Cloudmonks, to become master in the subject that mainly includes Informatica PowerCenter Client tools, Repository works, and Informatica PowerCenter Server, etc.

Our Online Informatica Training can be delivered in various formats, such as self-paced courses, live webinars, or a combination of both. Cloudmonks online training programs provide learners with access to instructors who can answer questions and provide feedback, while others are more self-directed.

Informatica PowerCenter is a popular data integration tool developed by Informatica Corporation. It is used to extract, transform and load (ETL) data from various sources to different targets. PowerCenter provides a single platform to integrate data from different sources and enables businesses to make informed decisions based on clean, reliable, and timely data.

PowerCenter offers a wide range of features such as connectivity to various data sources, data profiling, data quality, metadata management, and real-time data integration. It also provides a user-friendly interface that allows developers to design, develop, test, and deploy ETL mappings and workflows.

Course Features :

40 Hrs Instructer Led Training
Job Assistance
30 Hrs Self-paced Videos
Lifetime Video Access
Flexible Schedule
Mentor Support

Upcoming Live Online Classes :

Informatica Powercenter Cource Curriculum :

Module 1: Designer guide

Using the Designer

  • Configuring Designer Options
  • Using Toolbars
  • Navigating the Workspace
  • Designer Tasks
  • Viewing Mapplet and Mapplet Reports

Working with Sources

  • Working with Relational Sources
  • Working with COBOL Sources
  • Working with Cobol Source Files

Working with Flat Files

  • Importing Flat Files
  • Editing Flat Files Definition
  • Formatting Flat Files Column
  • File Type – Direct/Indirect

Working with Targets (File/Tables)

  • Importing Target Definition
  • Creating Target Definition from Source Definition
  • Creating Target Definition from Transformations
  • Creating Target tables


  • Working with Mappings
  • Connecting Mapping Objects
  • Linking Ports
  • Propagating Port Attributes
  • Working with Targets in a Mapping
  • Working with Relational Targets in a Mapping
  • Validating a Mapping
  • Using Workflow Generation Wizard


  • Understanding Mapplets Input and Output
  • Using Mapplet Designer
  • Using Mapplets in Mapping

Mapping Parameters and Variables

Working with User-Defined Functions

Using the Debugger

  • Creating Breakpoints
  • Configuring the Debugger
  • Monitoring the Debugger
  • Evaluating Expression

Creating Cubes and Dimensions

Using Mapping Wizard

Naming Conventions

Module 2: Transformation Guide

Working with Transformations

  • Configuring Transformations
  • Working with Ports
  • Working with Expressions
  • Reusable Transformations

Aggregator Transformation

Custom Transformation

Expression Transformation

External Transformation

Filter Transformation

Joiner Transformation

Java Transformation

Lookup Transformation

Lookup Caches

Normalizer Transformation

Rank Transformation

Router Transformation

Sequence Generator


Sorter Transformation

Source Qualifier Transformation

SQL Transformation

Stored Procedure Transformation

Module 3: Transformation Language Reference

The Transformation Language






Creating Custom Function

Module 4: Workflow Basics Guide

Workflow Manager

  • Workflow Manager Options
  • Navigating the Workspace
  • Working with Repository Objects
  • Copying Repository Objects
  • Comparing Repository Objects

Workflow and Worklets

  • Creating a Workflow
  • Using Workflow Wizard
  • Assigning an Integration Service
  • Working with Worklets
  • Working with Links


  • Creating a Session Task
  • Editing a Session
  • Pre- and Post- Session Commands

Session Configuration Objects Tasks

  • Creating a Task
  • Configuring Tasks
  • Working with Command Task
  • Working with Decision Task
  • Working with Event Task
  • Working Timer Task
  • Working with Assignment Task


  • Configuring Sources in a Session
  • Working with Relational Sources
  • Working with Flat Sources


  • Configuring Targets in a Session
  • Working with Relational Target
  • Working with File Targets
  • Reject Files


  • Validating Tasks
  • Validating Worklets
  • Validating Session
  • Validating Workflows

Scheduling and Running Workflows

  • Scheduling a Workflow
  • Manually Starting a Workflow

Sending Email

  • Working with Email Tasks
  • Working with Post-Session Email

Workflow Monitor

  • Using Workflow Monitor
  • Customizing Workflow Monitor Options
  • Working with Tasks and Workflows
  • Using Gantt Chart View and Task View

Workflow Monitor Details

  • Integration Services Properties
  • Workflow Run Properties
  • Worklet Run Properties
  • Session Task Run Properties
  • Performance Details

Session and Workflow Logs

  • Log Events
  • Log Events Window
  • Working with Log Files
  • Workflow Logs

Module 5: Administrator Guide

Understanding Domains

  • Nodes
  • Application Services

Using Administration Console

Managing the Domain

  • Managing Alerts
  • Managing Folders
  • Managing Permissions
  • Managing Application Services
  • Managing the Nodes

Managing Users and Groups

Managing Privileges & Roles

  • Domain Privileges
  • Repository Service Privileges
  • Repository Service Privileges
  • Managing Roles - Assigning Privileges and Roles to Users and Groups

Creating and Configuring the Repository Services

Managing the Repository

Creating and Configuring Integration Services

  • Enabling and Disabling the Integration Services
  • Running in Normal and Safe Mode
  • Configuring the Integration Services Processes

Integration Services Architecture

Creating the Reporting Services

  • Managing the Reporting Services
  • Configuring the Reporting Services

Managing Licence

Module 6: Advanced Workflow Guide:

Understanding Pipeline Partitioning

  • Partitioning Attributes
  • Dynamic Partitioning
  • Partitioning Rules
  • Configuring Partitioning

Partitioning Points

  • Adding and Deleting Partitioning points
  • Partitioning Relational Sources
  • Partitioning File Targets
  • Partitioning transformations

Partitioning Types

Real Time Processing

Commit Points

Workflow Recovery

Stopping and Aborting

  • Error Handling
  • Stopping and Aborting Workflows

Concurrent Workflows

Load Balancer

Workflow Variables

  • Predefined Workflow Variables
  • User- Defined Workflow Variables
  • Using Worklet Variables
  • Assigning Variable Values in a Worklet

Parameter and variables in Sessions

  • Working with Session Parameters
  • Assigning Parameter and Variables in a Session

Parameter File

Session Caches

Incremental Aggregation

Session Log Interface

Module 7: Command Reference

Using Command Line Programs

  • Infacmd
  • Infasetup
  • Pmcmd
  • pmrep

Module 8:Performance Tuning Guide

Performance Tuning Overview


  • Using Thread Statistics
  • Target Bottlenecks
  • Source Bottlenecks
  • Mapping Bottlenecks
  • Session Bottlenecks
  • System Bottlenecks

Optimizing the Targets

Optimizing the Source

Optimizing the Mapping

Optimizing the Transformations

Optimizing the Sessions

Optimizing the Power Center


Optimizing the System

Using Pipeline Partitions

Performance Counters

Module 9:Repository Guide

Understanding the Repository

Using Repository Manager


Managing Object Permissions

Working with Versioned Objects

Exporting and Importing Objects

Copying Objects

Train your teams on the theory and enable technical mastery of cloud computing courses essential to the enterprise such as security, compliance, and migration on AWS, Azure, and Google Cloud Platform.

Talk With Us