Informatica Powercenter Online Training

It is a collection of thick client workbench tools that Developers can use to create, execute, monitor and schedule ETL processes.The course will introduce attendees to working with the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data.

Informatica PowerCenter training is rendered by the best subject matter experts and the tutorials prepared by these expert industry allied tutors are made with latest industry updates. Classes are available for the individual as well as for corporate batches on demand. Call the help desk for more information for online Informatica PowerCenter Online Training’s and its details. It cover other ETL tools lies in its robustness.



  • Identify different Informatica Products
  • Describe PowerCenter as a tool to perform Extract transform & load
  • Interpret PowerCenter Architecture
  • its different components & their functionalities
  • Explaining  the advantages of component based development techniques in PowerCenter


  • ETL & ETL Architecture
  • Flat file & relational Sources using the Source Analyzer
  • Flat file & relational Targets using the Target Developer
  • Mappings using the Mapping Designer
  • Workflows using the Workflow Designer
  • Monitor the workflow using the Workflow Monitor
  • Preview Target Data using the PowerCenter Designer


  • Describe & Visualize PowerCenter Designer
  • Explain how to create the  mapping in Designer
  • Explain different Transformations & their usage


  • Understanding PowerCenter Workflow Manager
  • Describe Flow within a Workflow
  • Describe Re-usability & Scheduling in the Workflow Manager
  • Understanding components of Workflow Monitor
  • Understanding Workflow Task & job handling


  • Understanding the advanced features & functions of Transformations
  • Learn about the Java Transformation
  • XML File handling, Learn to use Normalizer Transformation
  • Learn some advanced concepts of the ETL
  • Learn about reusable objects in the Informatica


  • Understanding different Parameters & Variables used in PowerCenter
  • Describing Mapping Parameter & Variables
  • Learn to use the Session Parameters
  • Learn to use the Workflow Variables


  • Describing the basic Informatica PowerCenter training Error
  • Follow a basic troubleshooting methodology
  • Using the debugger
  • Use Workflow & Session logs to the diagnose errors
  • Recognize & repair, Connection Errors & Network errors
  • Design Error Handling Strategies for intended purpose
  • Understanding the recovery scenarios & mechanisms
  • Properly Configure Workflow & sessions for recovery
  • Understand the purpose of the High Availability
  • Monitoring the PowerCenter Environment


  • Understanding the session cache
  • Describe when & why cache is created
  • Implementing session cache
  • Learn to calculate cache requirement

  • Control how PowerCenter uses memory
  • Control how PowerCenter uses CPUs
  • Understanding the performance counters
  • Isolate source, target & engine bottlenecks
  • Tune different types of bottlenecks
  • Configure Workflow & Session on Grid


  • Recognize & explain the functionalities of the Repository Manager tool
  • Describing how to create & delete folders using the Repository Manager tool
  • Illustrate how to migrate components using Repository Manager Tool


  • Put in your own words an overview of PowerCenter Administration Console
  • Recognize & explain the integration & repository service properties
  • Identifying how to handle services in the Administration Console
  • Explaining how to handle locks through the Administration Console
  • Illustrate how to create users & groups


  • Understand Informatica 9.X Architecture
  • Describe the Application services related to PowerCenter & their related processes
  • Understanding the buffer memory
  • Describe Connectivity among the tolls
  • Describe Connection pooling used in PowerCenter


  • Step by step installations process
  • Configuration of the different Informatica PowerCenter training PC components & their set up
  • Backup & recovery, Operational procedures


  • Informatica frequently used commands
  • pmrep
  • pmcmd
  • infacmd
  • infasetup


  • SCD, XML Processing
  • Flat file handling
  • Different Transformations
  • For loop implementations in the PC
  • Partitioning
  • Pushdown optimization
  • Constraint based loading
  • Incremental Aggregations


  • ETL best practices using the Informatica PowerCenter training
  • Development Techniques
  • Error Handling & Data Migration
  • Performance Tuning

What is Powercenter?

Informatica PowerCenter training is single, unified enterprise data integration platform that allows companies and government organizations of all sizes to access, discover and integrate data from virtually any business system, in any format and deliver that data throughout the enterprise at any speed

The main advantages of Informatica PowerCenter Training cover other ETL tools lies in its robustness, for it can be used in both Windows and Unix based systems

Powercenter 9.6.1 can read from a variety of different sources and write to as many targets, while transforming data in between

The main advantage of powercenter over other ETL tools, and hence a reason for its popularity over other such tools are as follows:

  • Informatica PowerCenter training is robust, and can be used in both windows and Unix based systems
  • It is high performing yet very simple for developing, maintaining and administering

Informatica is an ETL tool which is used for extracting, transforming huge volumes of data and loading them into the targeted data warehouse. This informatica power center was developed by Informatica Corporation. Client tools, server, repository server and repository are the crucial components of Informatica power center. In this power center server and repository server build up the ETL layer which will complete the ETL testing process. Informatica is one of the leading tools used for data warehouse testing and the numbers of jobs are increasing day by day.

Course Topics for Informatica PowerCenter training:

  • Informatica Powercenter 9.x – an overview
  • ETL Fundamentals
  • Powercenter Designer
  • Powercenter Workflow Manager & Monitor
  • Advanced Transformation Techniques
  • Parameters & Variables
  • Debugging Troubleshooting Error Handling & Recovery
  • Cache
  • Performance Tuning & Optimization
  • Powercenter Repository Manager
  • Informatica Administration Console & Security
  • Informatica powercenter 9.7 – Technical Architecture
  • Informatica Installation & Operations Manual
  • Command line utilities
  • ETL Scenarios using Informaica
  • Best practises & velocity Methodologies

Course Objectives for Informatica PowerCenter training:

  •  The Information Economy
  • Etl- an Overview
  • Why ETL is still relevant?
  • Informatica Overview
  • Informatica Partners & Customers
  • Informatica Architecture Overview & Components
  • usecase1 – Loading Product Dimension table using slowly changing dimension (scd)
  • usecase2 – populate sales summary table using incremental Aggregation
  • Job trends
  • Scope of this course
Informatica Powercenter Products & Their Functionalities:

These are a wide range of products available under the informatica product suite that helps satisfy the data integration requirements within the enterprise and beyond

Informatica PowerCenter Training Product is a portfolio focused on Data Integration:

  • Data Integration & ETL
  • Information Lifecycle Management
  • Complex EVent Processing
  • Data Masking
  • Data Quality
  • Data Replication
  • Data Virtualization
  • Master Data Management
  • Ultra Messaging

Currently at version 9.6, these components from a toolset for establishing and maintaining enterprise-wide data warehouses

Powercenter – Fully integrated end-to-end integration platform, Informatica Powercenter Enterprise converts raw data into information to drive analysis, daily operations, and data governance initiatives

Infromation Lifecycle Management – Infromatica’s Infromation Lifecycle Management software empowers your IT Organizations to cost-effectively handle data growth, safely retire legancy systems and applications, opitimze test data management and protect sensitive data

Complex Event Processing – Informatica PowerCenter training Rule point is a complex event processing software that delivers robust and effective complex processing with real-time alerts and insight into pertinent information to operate ina smarter, faster, efficient and competitive way

Data Masking – Informatica Powercenter 8.5 Data Masking products dynamically mask sensitive production data from unauthorized access, permanently and irreversibly mask nonproduction data thereby helping IT organizations to comply with data privacy regulations, organization-wide data privacy mandates and reduce the risk of a data breach

Data Quality – Informatica PowerCenter training Data Quality provides clean, high-quality data regardless of size, data format, platform, or technology to the business. Helps validating and improving address information, profiling and cleansing business data, or implementing a data governance practice and ensure the data quality requirements and met

Data Replication – Informatica Data Replication is database-agnostic, real-time transaction replication software that’s highly scalable, reliable, and non-disruptive to the performance of operational source systems

Data Virtualization – Informatica Data Services provides a single scalable architecture for both data integration and data federation, creating a data virtualization layer that hides and handles the complexity of accessing underlying data sources – all while insulating them from change

Mater Data Management – The Informatica Master Data Management product family delivers consolidated and reliable business-critical data-also known as master data to the applications that employees rely on every day

Ultra Messaging – Informatica Ultra Messaging is a family of next generation, low-latency messaging middle ware products. with very high throughout and 24*7 reliability, they deliver extremely low-latency application messaging over both network-based and shared-memory based transports of Informatica PowerCenter training.

Who should go for this Informatica Powercenter online Training?

The course is designed for all those who want to learn Informatica

  • Developers who want to gain acceleration in their careers as an Informatica powercenter 9.X  administration Developer
  • Analytics Managers who are subject matter experts, leading a team of analysts
  • Individual Contributors in the field of Enterprise Business Intelligence

Informatica power center Training includes:

  • Informatica PowerCenter training architecture and concepts
  • Mapping and workflow fundamentals
  • Expression and filter transformations
  • Joining and merging data
  • Aggregate and sorter transformations
  • Usage of debugger and target tables updating
  • Mapping techniques
  • Creating and using reusable transformations
  • Mapplets, controlling workflows
  • Design mapping and design workflow workshop
  • Working on informatica using UNIX background