Informatica PowerCenter 9.x Level I Developer
     
 
 

Program Overview

This five-day Informatica Training Program provides the basic skills and knowledge developers who are new to Informatica PowerCenter are required to implement data integration projects, exposing core features of PowerCenter Informatica through lectures and hands-on exercises.

Agenda

Day 1

  • Module 1: Power Center: Terminology and architecture
  • Module 2: Mapping Fundamentals
  • Module 3: Workflow Fundamentals
  • Module 4: Expression and Filter Transformations

Day 2

  • Module 5: Joining and merging data
  • Module 6: Lookup Transformation
  • Module 7: Aggregator and Sorter Transformations
  • Module 8: Using the debugger

Day 3

  • Module 9: Updating target tables
  • Module 10: Mapping techniques
  • Module 11: Mapplets
  • Module 12: Controlling workflows

Day 4

  • Module 13: Mapping design workshop
  • Module 14: Workflow design workshop
  • Module 15: PowerCenter 9 New Features

Who should attend?

Suitable candidates for this informatica certification program are:

  • Database Developers who are new to Informatica PowerCenter
 

Prerequisites

Knowledge about data warehouse fundamentals.


Learning Objectives

After completing this program you should be able to:

  • Use PowerCenter 8 Designer to build mappings that move data from sources to targets
  • Use PowerCenter 8 Workflow Manager to build and run a workflow that runs a session based on a mapping
  • Design mappings and workflows based on business needs
  • Perform basic troubleshooting of PowerCenter mappings and transformations
  • Use Authorised Informatica Support options to resolve questions and problems about Informatica PowerCenter 8
  • Describe PowerCenter 9 New Features

Delivery Method

Public classroom training led by an Informatica Instructor

BUSINESS TRAINING PROGRAMS

CORPORATE LEARNING SOLUTIONS

Managed Training Services (MTS)