Informatica PowerCenter 10.x Foundation | Boot Camp for Developers

Informatica PowerCenter 10.x Foundation | Boot Camp for Developers



4 Days

Course Overview

The Informatica PowerCenter Boot Camp for Developers is a four-day, comprehensive foundation class teaches the fundamentals of the Informatica PowerCenter 10.x platform through lecture and numerous integrated hands-on lab exercises. Students will gain a clear understanding of the product and acquire a solid foundation needed to make them a successful PowerCenter developer.

Course Prerequisites

This course is geared for developers new to Informatica Power Center.

Course Agenda

Day One


  1. Getting Started
  • Course Objectives
  • Introduction to Informatica PowerCenter
  • Components & Architecture
  • Basic Concepts
  • Live Demo: creating and debugging a mapping


  1. Designer Overview
  • Interface
  • Folders
  • Workspaces


  1. Concepts
  • Sources and Targets
  • Mappings
  • Lab - Source and Target Definitions, Simple Mapping


  1. Transformation Objects in Depth I
  • Transformations Objects Overview
  • Source Qualifier
  • Expression Transformation
  • Aggregator Transformation
  • Filter Transformation
  • Lab - Expression, Aggregator, and Filter Transformations


Day Two


  1. Review Quiz


  1. Working with the Designer
  • Layout
  • Link Path
  • Compare Objects
  • Working with Transformations


  1. Using the Debugger
  • Debugging process and strategies
  • Discard Data Option
  • Flow Control
  • Breakpoints
  • Evaluate expressions


4. Working with Flat Files and Joiner Transformation

  • Importing and editing flat file sources/targets
  • Flat file data-types
  • Joiner Transformation
  • Lab - Joining flat file and relational data


  1. Transformation Objects in Depth II
  • Lookup Transformation
  • Stored Procedure Transformation
  • Rank Transformation
  • Using built-in functions
  • Lab - Lookup and Rank Transformations


  1. Local Variables
  • Overview
  • Using local Variables
  • Port evaluation


  1. Transformation Objects in Depth III
  • Sorter Transformation
  • Router Transformation


  1. Designer Tips
  • Auto Link
  • Propagate Attributes
  • Lab - Local variables, Sorter, and Router Transformations


Day Three


  1. Review Quiz


  1. Sharing and Reusing Designer Objects
  • Reusable transformations
  • Working with shortcuts


  • Lab - Mapplets


  1. User Defined Functions
  • Setup


  1. Transformation Objects in Depth IV
  • Union
  • Normalizer
  • Lab - Normalizer and User Defined Functions


  1. Transformation Objects in Depth V
  • Java Transformation
  • SQL Transformation
  • HTTP Transformation
  • Transaction Control



  1. Slowly-Changing Dimensions
  • Lab - Type 1 – Slowly Changing Dimension


Day Four


  1. Review Quiz


  1. Workflow Manager
  • Workspaces


  1. Simple Workflow
  • Creating
  • Session setup


  1. Workflow Monitor
  • Interface
  • Gantt Chart View
  • Task View
  • Controlling workflows and tasks
  • Viewing logs & session properties


  1. Workflow Error Handling
  • Sessions
  • Link Conditions
  • Lab - Simple Workflow and Error Handling


  1. Complex Workflows
  • Scheduler
  • Reusability
  • Wizard


  1. Workflow Tasks in Depth
  • Email Task
  • Command Task
  • Decision Task
  • Timer Task
  • Event Raise & Wait Task
  • Control Task
  • Worklets
  • Lab – Complex Workflow


  1. Parameters & Variables
  • In Mappings
  • In Sessions
  • In Workflow
  • Integration Service
  • Lab - Mapping Parameters and Variables

Course Materials

Each student will receive a Student Guide with course notes, code samples, software tutorials, diagrams and related reference materials and links (as applicable). Our courses also include step by step hands-on lab instructions and and solutions, clearly illustrated for users to complete hands-on work in class, and to revisit to review or refresh skills at any time. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Mix, Match & Master!
2FOR1: Two Courses, One Price!

Enroll in *any* two public courses (for 2023 *OR* 2024 dates!) by December 31, for one price!  Learn something new, or share the promo!

Click for Details & Additional Offers

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More