Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4

This course teaches the fundamentals of the Informatica PowerCenter v9.x platform, through lecture and numerous hands-on lab exercises.

Course Outline

This course teaches the fundamentals of the Informatica PowerCenter v9.x platform, through lecture and numerous hands-on lab exercises. Students will gain a clear understanding of the product and acquire the solid foundation needed to make them successful PowerCenter developers.

  • Course Introduction
  • Designer Overview
  • Live Demo: creating and debugging a mapping Concepts
  • Transformation Objects in Depth
  • Transformation Objects in Depth
  • Working with Flat Files
  • Designer: Clearing the Workspace
  • Using the Debugger
  • Designer Tips
  • Transformation Objects in Depth
  • Designer: Autolink
  • Designer: Link path
  • Local Variables Built-In Functions
  • User-Defined Functions

This course is designed for ETL developers with no previous PowerCenter experience

Course Outline

I. Course Introduction

A. Course Objectives
B. Introduction to Informatica PowerCenter
C. Components & Architecture

II. Designer Overview
A. Interface
B. Tools

III. Live Demo: creating and debugging a mapping

IV. Concepts
A. Mappings
B. Sources and Targets
C. Transformations Objects

V. Transformation Objects In Depth
A. Source Qualifier
B. Expression
C. Filter
D. Aggregator
E. Target Instance

VI. Student Lab 1
A. Expression and Aggregator Transformations

VII. Transformation Objects In Depth
A. Lookup

VIII. Working with Flat Files
A. Importing & editing flat file sources & targets
B. Flat file data-types

IX. Designer: Clearing the Workspace

X. Student Lab 2
A. Flat files, Lookups

XI. Review Quiz

XII. Using the Debugger

A. Debugging process and strategies
B. Breakpoints, evaluate expressions

XIII. Designer Tips
A. Documenting objects
B. Getting help

XIV. Transformation Objects in Depth
A. Stored Procedure
B. Router

XV. Designer: Autolink

XVI. Student Lab 3

A. Stored Procedure and Router Transformation

XVII. Designer: Link path
A. Transformation Objects In Depth
B. Sorter

XVIII. Local Variables
A. Using local variables
B. Port evaluation

XIX. Student Lab 4
A. Local Variables, Sorter Transformation
B. Transformation Objects in Depth
C. Rank
D. Joiner

XX. Built-In Functions
A. String functions, list functions

XXI. User-Defined Functions

XXII. Student Lab 5

A. Joiner Transformation, String functions

Prerequisites & Certificates

Certificates offered

Certificate of Completion

Cancellation Policy
10 Day cancellation required for all courses in order to get a full refund.
Map & Reviews
Protech Training
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
I took the training remotely so I cannot comment on some of the questions. I think that this seminar has too much content to squeeze it into one week.... might be better as a two week course?
Reviewed by 2013
found the material very helpful - although there was a lot of material covered - the pace was well set. Would definitely recommend people to have explored Microsoft Access beforehand to be familiarized with the program before taking the course. I would imagine someone without any exposure would find it confusing. Environment really good - people very, very nice and helpful. Would definitely take the next level of access with the same training facility.
Reviewed by 2013
I was not in the physical classroom. Feedback centered around online training would be good because now I have to rate items that I was not present for. Those items are getting half a star because I was not there to rate them. The course material must go through an editing process. There are a lot of grammar mistakes, but also a lot of actual procedure/activity mistakes.
Reviewed by 2012

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 334 times.