PowerCenter 8 Level II Developer Course Overview

This four-day, instructor-led course complements and extends “PowerCenter 8 Level I Developer” with advanced topics and extended labs. The course is intended for developers with more than six months of PowerCenter 8 experience. Topics covered include: Advanced Mapping Techniques; Advanced Workflow Techniques; Transaction Control; Workflow Recovery; Error Handling; Performance Tuning; Stored Procedures and Custom Transformations; Repository Reporting; Memory Allocation; and Pipeline Partitioning.

If you would like to book a course, please click here and one of our team will contact you. Alternatively, please call us directly on 0141 582 1380.

Course Details

• 4 day course
• Instructor led
• £2000 per student

Objectives

After completing this course you should be able to:

• Describe the PowerCenter 8 architecture
• Given a mapping specification, build a corresponding mapping, using the techniques including: variables and parameter files; dynamic caching; data-driven and incremental aggregation; denormalization; user-defined and custom functions
• Control workflow behavior with restart junctions, control tables, workflow variables, and dynamic scheduling
• Configure workflows for recovery
• Use transaction control to manage writing to targets
• Configure PowerCenter’s handling of data errors
• Manage objects in one or more repositories
• Optimize PowerCenter’s memory usage
• Using a standardized methodology, optimize the performance of PowerCenter in your environment
• Use partitions and stages to improve performance

Agenda

Module One: Architecture Overview and High Availability

• Architectural overview
• Domains, nodes, and services
• Configuring services
• High Availability

Module Two: Mapping Specifications and Parameters

• Velocity mapping specifications
• Mapping parameters and variables
• Parameter files
• Normalizer Transformation

Labs:   Dynamically update mapping variable

Create/use parameter files

Module Three: Caching and Aggregation

• Dynamic lookup cache
• Data driven aggregation
• Incremental aggregation

Labs:   Dynamic Lookup

            Data-driven aggregation

            Incremental aggregation

Module Three: Custom and User-Defined Functions

• User-defined functions
• Custom functions
• Custom transformations

Lab: User-defined functions

Module 5: Controlling Workflow Execution

• Timer and Email Tasks
• Control Tasks
• Restart Junctions
• Alerts
• Pseudo-Looping

Labs: Using timer and control tasks; starting one workflow from another workflow

Module 6: Dynamic Scheduling

• Business Case
• Workflow Variables
• Assignment Task

Lab: Workflow variables and assignment tasks

Module 7: Workflow Recovery

• Task recovery strategy
• Session recovery strategy
• Command task recovery strategy
• Options in HA
• States of operation
• Repeatable data
• pmcmd

Lab: Configure for recovery and recover a suspended workflow

Module 8: Transaction Control

• Database Transactions
• Transaction Control Transformation
• Transformation Scope

Lab: Use flags to control commit of invoice numbers

Module 9: Error Handling

• Row error categories
• Error log options
• Error handling strategies
• Transaction control example

Labs: rollback based on errors; write errorred rows to correct targets

Module 10: Finding, Migrating, and Comparing Repository Objects

• Object queries
• Folder migration
• Session migration
• Deployment groups
• Managing folder status
• Rollback
• Comparing objects

Lab: Object queries

Module 11: Repository Metadata

• Repository Reports
• Data Lineage
• Metadata Exchange

Module 12: Memory Optimization

• Data Transformation Manager memory
• Lookup transformation cache
• Aggregator cache
• Sorter cache
• Joiner cache
• Automatic memory attributes

Module 13: Performance Tuning

• Production environment
• Bottlenecks and benchmarks
• Identifying bottlenecks
• Optimization
  • Target
  • Source
  • Mapping
  • Mapping/Session
• Lookup example
• Cached values and sequence generation
• Performance counters

Lab: Optimize an existing session

Module 14: Pipeline Partitioning

• Pipelines
• Threads, partition points, and stages
• Adding partitions
• Partition types
• Pipeline partitioning example
• Dynamic partitioning

Lab: Determine correct partitioning for existing sessions

If you would like to book a course, please click here and one of our team will contact you. Alternatively, please call us directly on 0141 572 1380.