Informatica PowerCenter 9.x/10.x: Developer, Level 1

Catalog Home Databases, Business Intelligence & Data Science Informatica
Your Training Location:  

Informatica PowerCenter 9.x/10.x: Developer, Level 1

Instructor Led
Loading Course Dates...
No available dates in this city.

  Available by Request
{{date.date_begin | date:'M/d'}} - {{date.date_end | date:'M/d/yyyy'}}
ViewHide Additional Dates

This four day, instructor-led course introduces students to Informatica PowerCenter 9.6/10.x through lecture and hands-on exercises. The course is designed for Database Developers who are new to Informatica PowerCenter. Informatica PowerCenter 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. They will develop cleansing, formatting, sorting and aggregating procedures. They can learn how to use routers, update strategies, mapping parameters /variables and overrides. This course will cover many different types of lookups, such as cached, persistent, and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL.

There are no prerequisites for this course.

4 Days/Lecture & Lab

This course is designed for Data Integration developers with little or no experience of PowerCenter.

  • An Overview of Informatica PowerCenter 9.6/10.x
  • ETL Fundamentals
  • Trouble Shooting
  • PowerCenter Transformations, Tasks, and Reusability
  • Features and Techniques
  • Joins and Link Conditions
  • Using the Debugger
  • Sequence Generators, Lookups, and Caching
  • Update Strategies, Routers, and Overrides
  • Sorter, Aggregator, Unconnected Lookups, Mapping Parameter/Variables, and Mapplets/Worklets
  • Mapping Design Workshop
  • Workflow Design Workshop

< >

Copyright © 2021 ProTech Professional Technical Services, Inc. All Rights Reserved.

Sign In Create Account


Social Media