Informatica PowerCenter 9.x Level 1

Informatica PowerCenter 9.X Developer & Admin Course, will introduce the participants to work with the PowerCenter. Developers can use Informatica to create, execute, as well as administer, monitor and schedule ETL processes and understand how these are used in data mining operations. The course will also cover Installation & Configuration of Informatica PowerCenter 9.X and basic Administration Activities. Participants will also get to implement one project towards the end of the course.

  • 24 hours of Direct to Device, Instructor-Led Sessions
  • Program Helps in Empowering business users with the right information at the right time.
  • Program Helps in Seamlessly integration of data from disparate systems for a cohesive data foundation.
  • Guided Assignments for hands-on learning
  • The course will prepare you for handling Installation & Configuration of Informatica PowerCenter 9.X and basic Administration Activities.

Online Instructor-Led

batch loading...

Course Features

About Informatica PowerCenter 9.x Level 1

The course is designed for Database Developers who want to shift their career to Informatica PowerCenter. This course introduces students to Informatica PowerCenter 9.5. Informatica PowerCenter is a collection of thick client workbench tools that developers use to create, execute, monitor, and schedule ETL processes.

Learners will be introduced to working with the PowerCenter Designer, Workflow Manager, and Workflow Monitor Tools. They will be taught to perform tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform, and load data. They will also develop cleansing, formatting, sorting and aggregating procedures.

This course teaches learners how to use routers, update strategies, mapping parameters /variables and overrides. It also covers many different types of lookups, such as cached, persistent, and multiple row returns. The course will also teach how to create workflow tasks to define a set of instructions for executing ETL.

Course Objectives
  • Get the basics of Informatica PowerCenter 9.
  • Learn PowerCenter 9.5 Designer to build mappings that extract data from a source to a target and transforming it as necessary.
  • Learn PowerCenter transformations to cleanse, format, join, aggregate and route data to the appropriate targets.
  • Get the insights of error handling and trapping using PowerCenter mappings.
  • Acquire knowledge of PowerCenter 9.5 Workflow Manager to build and run a workflow which executes a sessions associated with a mapping.
  • Design and build simple mappings and workflows based on essential business needs.
  • Get the basic troubleshooting techniques using PowerCenter logs and debugger.
Module 1:

An Overview of Informatica PowerCenter 9.

  • Oerview of PowerCenter covering areas such as the Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor.
Module 2:

ETL Fundamentals.

  • Flat file and relational Sources using the Source Analyzer. Flat file and 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.
Module 3:

Trouble Shooting.

  • Understand PowerCenter Log files. Use PC log files to: View and look up error messages. Correct mapping and workflow errors.
Module 4:

PowerCenter Transformatiopns, Tasks and Reusability.

  • Define list of PC Designer Transformations and Workflow Task. Clarify Active vs. Passive Transformations. Use the Expression Transformation and Editor in a mapping which applies a file list to load multiple flat files into a stage table utilizing expression and filter transformations to format and screen erroneous customer data. Use Reusable Designer Transformations to apply same formatting logic to Employee records.
Module 5:

Joins and Link Conditions.

  • Define Joins. Clarify Heterogeneous vs Homogeneous Joins. Use a Joiner Transformation to join relational and flat file sources. Use the Source Qualify to join two relational sources. Make use of Link Conditions to execute one session when the first finishes successfully.
Module 6:

Using the Debugger.

  • Outline Debugger Interface. Show creation of a break point. Show Evaluate the Expression™ functionality. Re-Execute mapping withdifferent values.
Module 7:

Sequence Generators, Lookups and Caching.

  • Define the Sequence Generator. Define the Lookup Transformation. What are the different types of Lookups? Clarify Lookup Caching. Use a Flat File Lookup to add data to a relational target. Build a Dates Lookup Cache for use in determining start and end dates of target records. Utilize Event Wait, Event Timer and Email Tasks to wait for flat files and email users upon successful/failed load.
Module 8:

Update Strategies, Routers and Overrides.

  • Build a mapping that uses Update Strategies and Routers to determine insert/update logic for a target.  Overrides will be used for incremental (daily) loading of the target.
Module 9:

Sorter, Aggregator, Unconnected lookups, Mapping Parameter/Variables and Mapplets/Worklets.

  • Define Sorter Transformation. Detail Aggregator Transformation and Aggregate Functions. Explain Unconnected Lookups and how they are called. Describe Mapping Parameters/Variables and initialization priority. Outline Mapplets and Worklets. Use these Transformations to create a mapping which loads records from warehouse Dimension tables to a Fact table.
Module 10:

Workflow Variables and Tasks.

  • Use PC workflow variables to pass information from one point in a workflow to another. Use an Assignment task to establish the value of a workflow variable within a workflow. Use a decision task to set criteria by which the workflow will decide which execution branch to follow.
Module 11:

Parameter Files and Command Tasks.

  • Use a Parameter file to make mappings and workflows more flexible by defining values for mapping variables, source files, database connections for sessions and workflow log files. Command Tasks will be used to run scripts to rename and move files.
Module 12:

Dynamic Lookups, More Lookup Functionality and Error Logging/Handling with Workshop on Workflow and mapping.

  • Use Dynamic Lookup, Router and Update Strategy in a mapping do a lookup on the target table and determine if the record should be an insert, update or logged to a file as an error. Use PowerCenter Best Practices to create a mapping to trap fatal and non-fatal errors. Create a Multiple Row Return Lookup, use Aggregators and Expressions to count the number of orders a Customer has as well as total the sales for that customer. Add those values to a target. Business requirements details will be provided so that the student can design and build their own mapping necessary to load a Promotions Aggregate table. The workshop will provide Velocity Best Practices documents that can be used to determine the correct logic for the mapping. Business requirements details will be provided so that the student can design and build their own workflow necessary to load all staging tables in a single workflow. The workshop will provide Velocity Best Practices documents that can be used to determine the correct logic for the workflow.

Instructors are handpicked from a selected group of industry experts and mentors and trained to deliver the best online learning experience. All instructors have at least ten years of industry experience and extensive functional expertise in the field they train.

  • The assessment will be done on the basis of an online test and Project Evaluation at the end of the course.
  • Weightage of Project Evaluation is 30% and that of Online test is 70%. Minimum pass percentage for online test is 70.
  • On completion of the Assessment (Project + Test) with a minimum of 70% marks, will issue a certificate of successful completion from NIIT.
  • Five re-attempts will be provided to clear online test in case the candidate scores less than 70%.
  • A Participation certificate will be issued if the candidate does not score 70% in the Assessment.
  • Soft copy of the certification will be issued to the participants, on completion of the course.

The prerequisites for the program are:

  • The learner should have basic programming knowledge, preferably in Windows GUI.
  • The learner should have a fair working knowledge in SQL Server.

Who should join this course?

This course is for Data Integration developers with little or no experience of PowerCenter. The course is designed for Database Developers who want to shift their career to Informatica PowerCenter. This course introduces students to Informatica PowerCenter 9.5. Informatica PowerCenter is a collection of thick client workbench tools that developers use to create, execute, monitor, and schedule ETL processes.

Why should I join this course?

This course will teach learners to use Informatica to create, execute, administer, monitor, and schedule ETL processes. This course provides insights on how to use the Informatica concepts in data mining operations. The course will also cover Installation & Configuration of Informatica PowerCenter 9.X and basic Administration Activities.

Do you provide any study materials?

Relevant reference material and web links will be shared with the candidates through our discussion forum and batch email list.

What happens if I miss a session?

All the live sessions are recorded and available for later view. Learners can refer to recordings of a missed session at their convenience.

What is your refund policy?

Upon registering for the course, if for some reason you are unable or unwilling to participate in the course further, you can apply for a refund. You can initiate the refund any time before start of the second session of the course by sending an email to , with your enrolment details and bank account details (where you want the amount to be transferred). Once you initiate a refund request, you will receive the amount within 21 days after confirmation and verification by our team. This is provided if you have not downloaded any courseware after registration.

What are the minimum system requirements to attend the program?

    Minimum system requirements for accessing the courses are:

  • Personal computer or Laptop with web camera
  • Headphone with Noise Clarity Microphone
  • Broadband connection with minimum bandwidth of 4 mbps.
  • Its recommended to use System Health Check to examine the OS details, Add in, Plugins, Camera, Mic and other external devices.

Is there an official support desk for technical guidance during the training program?

Yes. For immediate technical support, you can reach out on 91-9717992809 or 0124-4917203 between 9:00 AM and 8:00 PM IST. You can write to for all other queries and our team will be happy to help you.

Course Features

batch loading...

Related Courses

AI and Deep Learning with TensorFlow
AWS Certification and Training Program
Active Directory® Services with Windows Server®
Administering Microsoft Exchange Server 2016
Administering Microsoft® SQL Server® 2014 Databases
Administering System Center Configuration Manager and Intune
Administering Windows Server® 2012
Administering the Web Server IIS Role of Windows Server
Administration Essentials for New Admins- Salesforce
Advanced Automated Administration with Windows PowerShell®
Advanced Data Mining projects with R
Advanced Pay Per Click
Advanced Social Media Marketing
Advanced Solutions of Microsoft Exchange Server 2013
Advanced Solutions of Microsoft® SharePoint® Server 2013
Analyzing Data with Power BI
Analyzing and Visualizing Data with Excel
Analyzing and Visualizing Data with Power BI
Android Game Development for Beginners
Angular 5
Application Development with Swift 2
Automated UI Testing in Java
Automating Administration with Windows PowerShell®
Big Data Analytics with R
Big Data Applications using Hadoop
Building Android Games with OpenGL ES
Building Applications with Ext JS
Building Applications with
Building a Data Mart with Pentaho Data Integration
Building iOS 10 Applications with Swift
Builiding web application with spring MVC
Business Analytics using R from KPMG
Business Analytics using R from KPMG – Advanced
Business Analytics using R from KPMG – Expert
Certified Digital Marketing Professional
Cloud and Datacenter Monitoring with System Center Operations Manager
Complete Web and Social Media Analytics
Configuring Advanced Windows Server® 2012 Services
Core Solutions of Microsoft® Exchange Server 2013
Core Solutions of Microsoft® SharePoint® Server 2013
Core Solutions of Skype for Business 2015
Data Quality 9.x: Developer, Level 1
Data Science Orientation
Data Science with R
Data Science with Spark
Deploying Windows Desktops and Enterprise Applications
Designing and Deploying Microsoft Exchange Server 2016
Designing and Implementing a Server Infrastructure
DevOps Certification Training
Developing Microsoft Azure Solutions
Developing Microsoft SharePoint® Server 2013
Developing Microsoft SharePoint® Server 2013 Core Solutions
Developing SQL Databases
Enabling and Managing Microsoft Office 365
Fundamentals of a Windows Server® Infrastructure
GNIIT Foundation
Getting Started with R for Data Science
Getting started with Apache Solr Search Server
IBM Cognos Connection and Workspace Advanced
IT Service Management with System Center Service Manager
Implementing Microsoft Azure Infrastructure Solutions
Implementing Microsoft Azure Solutions-70-533
Implementing a Data Warehouse with Microsoft® SQL Server® 2014
Informatica PowerCenter 9.x Level 1
Installing and Configuring Windows 10
Installing and Configuring Windows Server® 2012
Introducing Rails 5 Learning Web Development the Ruby Way
Introduction to ITIL
Introduction to SQL Databases
Introduction to Web Development with Microsoft Visual Studio 2010
Java Enterprise Apps with DevOps
Joomla Certification Training Program
Julia for Data Science
Learning Android N Application Development
Learning Data Mining with R
Learning Joomla 3 Extension Development
Learning MongoDB
Learning R for Data Visualization
Learning Spring Boot
Learning Swift 2
Linux shell scripting solution
Machine Learning with Python
Marketing Analytics Data Tools and Techniques
Mastering Magento
Open Source Web App Development using MEAN Stack
PMI® Agile Certified Practitioner Training
Pentaho Reporting
Performance Tuning and Optimizing SQL Databases
Planning and Deploying System Center 2012 Configuration Manager
Programming Using Python
Programming in C Sharp
Programming in HTML5 with JavaScript and CSS3
Programming with Python for Data Sciences.
Project Management Professional (PMP®) Training
Querying Data with Transact SQL
Querying Microsoft SQL Server® 2014
R Data Mining Projects
R for Data Science Solutions
Reactive Java 9
SAS Certification Training Program
Secrets of Viral Video Marketing
Selenium with Java
Six Sigma Certification Training Program
Spring Security
Supply Chain Management(SCM) Training Program
Supporting and Troubleshooting Windows 10
Teradata Certification Training
Test Driven Android
UNIX Shell Scripting Training
Upgrading Your Skills to MCSA Windows Server 2016
Upgrading Your Skills to MCSA Windows Server® 2012
Web Apps Development using Node.js along with Express.js and MongoDB
Web Apps Development with HTML5, CSS3, jQuery & Bootstrap
Web Development with Node.JS and MongoDB
iOS App Development Certification Training
jquery UI Development