Course Description | Outline | IT Home

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