Informatica Powercenter Certification Training - Simplilearn | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Informatica Powercenter Certification Training - Simplilearn


Format What’s this?
Starting From
RM 1285.70
  1. 0 Hours
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
  3. 180 days of access from date of purchase
  1. 0 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.
Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy




Thank You

Our learning consultant will get back to you in 1 business day

Informatica Powercenter Certification Training - Simplilearn


This Informatica training by Simplilearn equips you with all skills required to step into the field of ETL and data warehousing using the most in-demand tool. Informatica PowerCenter. This course builds your competency in developing beginner to intermediate level of PowerCenter objects and to expertise in the practical use of the Designer, Workflow Manager, Workflow Monitor tools, and master advanced transformations concepts.


This course is perfect for taking your initial steps into the field of ETL and data warehousing. This training is designed for:

• ETL and data-warehousing professionals

• SQL and database Developers

• Business Intelligence Professionals

• Mainframe Professionals

• Project Managers

• Professionals planning to appear for the Powercenter Developer Certification


There are no prerequisites for this training but some good to know topics are SQL, databases and some scripting language.


After completing this course you will be able to:

• Understand Basic Mapping Design including the use of Informatica PowerCenter Designer, Workflow manager, and workflow monitor tool

• Master source qualifier, expression, aggregator, lookup, filter, joiner and other kinds of transformations

• Add transformations using input and output ports

• Work with transformation functions and expression syntax

• Implement SCD1, SCD2, and SCD3 mappings

Expand All


Module 1 – Downloading Informatica Power Center 9.x

• The Course Overview

• Downloading the Tool
• Extracting the Tool from Its .zip File

Module 2 – Installing and Configuring Power Center Introduction

• Installing the Server

• Installing the Client

Module 3 – Getting Familiar with the Admin Console

• Configuring Domain and Node

• Configuring Repository and Integration Service

Module 4 – Setting up Security, Permissions, and Client Configuration

• Configuring Users and Granting Permissions

• Configuring the Repository Manager

Module 5 – Using the Designer Screen

• Using the Designer Client Interface

• Working with Sources as Files and Databases

• Working with Targets as Files and Databases

Module 6 - Creating Mappings

• Creating a New Mapping

• Getting Acquainted with the Workflow Manager Screen

Module 7 - Adding Transformation Using Input and Output Ports

• Using the Workflow Manager Interface

• Using the Workflow Manager

Module 8 – Setting Up a Path and Connection

• Setting the Source And Target Paths

• Executing the Workflow

Module 9 - Getting Accustomed to the Workflow Monitor Screen

• The Workflow Monitor

• The Workflow Log, Session Log, And Run Properties

Module 10 - Working with the Repository Manager Screen

• Copy Paste and Drag Drop Features

• The Export Import Feature

Module 11 - Using Transformations

• The Course Overview

• The Expression Transformation

• The Aggregator Transformation

• The Sorter Transformation

• The Filter Transformation

• The Router Transformation

Module 12 - Using Advanced Transformations

• The Rank Transformation

• The Joiner Transformation

• The Union Transformation

• The Source Qualifier Transformation

• The Sequence Generator Transformation

Module 13 - More Advanced Transformations

• Classification of Transformation

• The Lookup Transformation

• Types of Caches

• The Update Strategy Transformation

• The Stored Procedure Transformation

Module 14 - Implementing SCD

• Understanding SCD Types

• Implementing SCD1 Mapping

• Implementing SCD2 Mapping

• Implementing SCD3 Mapping

To Be Confirm

To Be Confirm

Read More

Course Reviews

No Remarks


0 Ratings