UMBC Training Centers logo

Informatica PowerCenter 8.x Level II Developer

 

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