This two day PowerCenter Operations and Support instructor-led course provides basic skills and knowledge to people working in a PowerCenter support role. This course will prepare you for that challenge by giving you a through overview Informatica’s development suite of tools, that you may better understand how to troubleshoot oddities and processes that generate errors or process failures.The labs in this course take you from learning the basics of mapping design all the way through operator level processing. In all of this, you will be guided by Informatica’s Velocity methodology.

Target Audience

  • PowerCenter operational support
  • ETL project managers
  • Team Leads

Prerequisites

  • Experience in operations environment of assigned area
  • General knowledge of client/server computing environment technologies
  • Understanding of server operating systems
  • Administrator experience
  • Basic problem solving skills
  • Some familiarity with database
  • Connectivity requirements and locations of source / target objects used for ETL processing

Objectives

  • Use PowerCenter 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.
  • Understand PowerCenter’s technical connectivity requirements to source or load data from various sources of data.
  • Learn the various ways a PowerCenter session or workflow can be started.  Understand and work with the PowerCenter scheduler.
  • Examine the properties of the PowerCenter High Availability option.
  • Learn the command line syntax to schedule a PowerCenter process from the command line via a 3rd party scheduler or script.
  • Learn the primary troubleshooting processes to diagnose errors related to a failed load.
  • Learn the various PowerCenter recovery options for tasks and workflows including how to recover a failed session.
  • Apply Informatica recommended Best Practices to the Operations process transformations

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
  • PowerCenter 8.x Architecture

Module 2: Understanding ETL Mappings and Sessions

  • Be familiar with mapping components
  • Understand mapping validation
  • Understand the effects of editing mappings
  • Be familiar with basic session properties
  • Know the relationship between mappings, sessions and reusable sessions

Module 3: Operational Connections

  • Be familiar with connection objects
  • Set connection objects on a Session
  • Use connection objects and variables
  • Be familiar with connection permissions
  • Set connections with a parameter file
  • Configure a session to use flat file sources and targets

Module 4: Recovery Basics

  • Recover a Workflow has that stopped, aborted or terminated
  • Restart a Session Task

Module 5: Understanding and 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
  • Discuss Concurrent Workflows

Module 6: Monitoring Workflows

  • Be familiar with Workflow Monitor views and components
  • Connect to Integration services
  • Connect to folders
  • Examine the execution of workflows, tasks and their statuses
  • Examine session run statistics
  • Customize the Workflow Monitor

Module 7: Basic Troubleshooting

  • Become familiar with basic PowerCenter errors
  • Learn a 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
Print Friendly, PDF & Email