Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Gold Training Partner
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Informatica PowerCenter Boot Camp for Developers 8.6 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

 

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.



Comments on the Course

Call for availability