PowerCenter : Operations and Support (PC9OS)

Examine the basic skills and information needed for those in a PowerCenter support role. Students become prepared for day-to-day challenges by reviewing a through overview of Informatica’s development suite of tools in order to better understand how to troubleshoot oddities and processes that generate errors or process failures. Study mapping developments, workflow monitoring, connectivity, troubleshooting and recovering failed sessions. The hands on labs will walk through the basics of mapping design through operator level processing.
 
Objectives
After successfully completing this course, participants should be able to:
  • Use PowerCenter 9.5.x software to create and understand basic mappings that move data from sources to targets, basic sessions and workflows, and observe the load process and analyze results for successful and failed processes.
  • Recognize PowerCenter’s technical connectivity requirements to source or load data from various sources of data.
  • Discover the various ways a PowerCenter session or workflow can be started.
  • Understand and work with the PowerCenter scheduler.
  • Use the command line syntax to schedule a PowerCenter process from the command line via a 3rd party scheduler or script.
  • Process basic troubleshooting methodologies to diagnose errors related to a failed load.
  • Implement the various PowerCenter recovery options for tasks and workflows including how to recover a failed session.
  • Examine the properties of the PowerCenter High Availability option.
  • Apply Informatica recommended Best Practices to the Operations process transformations
 
Target Audience
  • PowerCenter operational support
  • ETL project managers
  • Team Leads
 
Prerequisites
  • General knowledge of client/server computing environment technologies
  • Understanding of server operating systems
  • Some familiarity with database connectivity requirements and locations of source / target objects used for ETL processing
  • Administrator experience
Show details
Agenda
Module 1: PowerCenter Functionality & Architecture
  • PowerCenter 8.x Architecture
  • PowerCenter Application services
  • The relationships between the major types of PowerCenter Services
  • How each PowerCenter client application is used
Module 2: Understanding ETL Mappings and Sessions
  • Become familiar with mapping components
  • Review mapping validation
  • Identify the effects of editing mappings
  • Go over the basic session properties
  • Distinguish the relationship between mappings, sessions and reusable sessions
Module 3: Operational Connections
  • Be familiar with connection objects and permissions
  • Set connection objects on a Session
  • Use connection objects and variables
  • Set connections with a parameter file
  • Configure a session to use flat file sources and targets
Module 4: Understanding the Scheduling Workflows
  • Set and use workflow parameters and variables
  • Discuss the different types of workflow tasks
  • Use Link conditions and Decision tasks to control the execution of a workflow
  • Explain the purpose of the pmcmd utility
  • Schedule workflows to run automatically
  • Examine Concurrent Workflows
Module 5: Monitoring Workflows
  • Become familiar with Workflow Monitor views and components
  • Connect to Integration services and folders
  • Examine the execution of workflows, tasks and their statuses
  • Study session run statistics
  • Customize the Workflow Monitor
Module 6: Basic Troubleshooting
  • Learn to recognize basic PowerCenter errors
  • Discover the basic Troubleshooting Methodology
  • Use Workflow and Session logs to diagnose errors
  • Understand how to recognize and repair connection errors and network errors
  • Be familiar with user errors
Module 7: Recovery Basics
  • Recover a Workflow has that stopped, aborted or
  • terminated
  • Restart a Session Task
Module 8: Overview of High Availability
  • Recognize the types of High Availability
  • Understand how resilience works
Module 9: Deployments
  • Know how to deploy PowerCenter metadata from
  • development to test, and then to production environments
Module 10: Command Line Operations
  • Identify how to start and stop workflows with command line syntax
  • Understand how to use invoke workflows via PMCM