Informatica PowerCenter Boot Camp for Developers 8.6

4 Days

Description

Teaches the fundamentals of the Informatica PowerCenter 8.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.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Informatica PowerCenter Boot Camp for Developers 8.6 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

Day One

1.Course Introduction

  • Course Objectives
  • Introduction to Informatica PowerCenter
  • Components & Architecture

2.Designer Overview

  • Interface
  • Tools

3.Live Demo: creating and debugging a mapping

4.Concepts

  • Mappings
  • Sources and Targets
  • Transformations Objects

5.Transformation Objects In Depth

  • Source Qualifier
  • Expression
  • Filter
  • Aggregator
  • Target Instance

6.Student Lab 1

  • Expression and Aggregator Transformations

7.Transformation Objects In Depth

  • Lookup

8.Working with Flat Files

  • Importing & editing flat file sources & targets
  • Flat file data-types

9.Designer: Clearing the Workspace

10.Student Lab 2

  • Flat files, Lookups

Day Two

1.Review Quiz

2.Using the Debugger

  • Debugging process and strategies
  • Breakpoints, evaluate expressions

3.Designer Tips

  • Documenting objects
  • Getting help

4.Transformation Objects In Depth

  • Stored Procedure
  • Router

5.Designer: Autolink

6.Student Lab 3

  • Stored Procedure and Router Transformation

7.Designer: Link path

8.Transformation Objects In Depth

  • Sorter

9.Local Variables

  • Using local variables
  • Port evaluation

10.Student Lab 4

  • Local Variables, Sorter Transformation

11.Transformation Objects In Depth

  • Rank
  • Joiner

12.Built-In Functions

  • String functions, list functions, ...

13.User-Defined Functions

14.Student Lab 5

  • Joiner Transformation, String functions

Day Three

1.Review Quiz

2.Designer: Propagate attributes

3.Sharing and Reusing Designer Objects

  • Reusable transformations
  • Working with shortcuts

4.Transformation Objects In Depth

  • Union
  • Normalizer
  • Java Transformation
  • SQL Transformation
  • HTTP Transformation
  • Transaction Control

5.Student Lab 6

  • Normalizer, reusable transformations

6.Mapplets

7.Designer: Foreign Key Relationships

8.Student Lab 7

  • Mapplets

9.Transformation Objects In Depth

  • Update Strategy
  • Sequence Generator

10.Slowly-Changing Dimensions

11.XML

  • Sources and targets
  • Parser and generator
  • Editor overview

12.Student Lab 8

  • Slowly changing dimension type 1

Day Four

1.Review Quiz

2.Workflow Manager

  • Menus & tools
  • 5 steps to creating a workflow
  • Session properties

3.Workflow Monitor

  • Interface
  • Controlling workflows and tasks
  • Viewing logs & session properties
  • Gantt Chart View & Task View

4.Student Lab 9

  • Simple Workflow

5.Workflow Tasks

  • Command
  • Email
  • Decision
  • Timer
  • Control
  • Event Raise & Wait

6. Worklets

7. Student Lab 10

  • Worklets and Complex Workflows

8. Parameters and variables

  • In mappings
  • In sessions and workflow
  • parameter files

9. Student Lab 11

  • Mapping parameters and variables

10. Team Based Development Overview

  • Version Control 101
  • Checking Out and Checking In objects
  • Repository queries

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Informatica PowerCenter Boot Camp for Developers 8.6 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

Target Audience:

  • ETL developers with no previous PowerCenter experience

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Informatica PowerCenter Boot Camp for Developers 8.6 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Comments

Call for availability

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Informatica PowerCenter Boot Camp for Developers 8.6 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date