Facebook Pixel
Black Friday Sale
LIVE NOW - CLICK HERE
OFFERS END IN:
Up to 50% off - Use offer code: BLACKFRIDAY19USA

Informatica Powercenter

Course type:
E-learning
Duration:
Delivery:
Online
From {% configuredPrice() | ilxCurrency:currentCurrency %} Was {% configuredPrice() | ilxCurrency:currentCurrency %}
From {% configuredOfferPrice() | ilxCurrency:currentCurrency %}
Without exams

Informatica Powercenter E-learning

Informatica PowerCenter is a widely used extraction, transformation and loading (ETL) tool used for data integration. 

The Informatica PowerCenter course trains you on various aspects of the Informatica administrator console and transformations. You will understand slowly changing dimension problems to sharpen your data warehousing skills.

Course overview

About the course

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

What's covered?

The course will cover the following topics:

  • Lesson 1 - Downloading Informatica PowerCenter 9.x 
  • Lesson 2 - Installing and configuring PowerCenter 
  • Lesson 3 - Getting familiar with the admin console 
  • Lesson 4 - Setting up security, permissions, and client configuration 
  • Lesson 5 - Using the designer screen 
  • Lesson 6 - Creating mappings
  • Lesson 7 - Adding transformation using input and output ports 
  • Lesson 8 - Setting up a path and connection 
  • Lesson 9 - Getting accustomed to the workflow monitor screen 
  • Lesson 10 - Working with the repository manager screen 
  • Implementing Informatica PowerCenter 9

Target audience

This course is perfect for taking your initial steps into the field of ETL and data warehousing. It's suitable for:

  • ETL and data-warehousing professionals
  • SQL and database developers
  • Business intelligence professionals
  • Mainframe professionals
  • Project managers

Pre-requisites

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

Learning objectives

By the end of the 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

What's included?

Informatica PowerCenter is offered by Simplilearn, a partner of ILX Group.

Duration of access

12 months online access to accredited e-learning

Exam information

There is no exam available, but you must complete 85% of the course to obtain a certificate.