PowerCenter 9.x: Operations and Support

Instructor-led | PowerCenter | 2 Days (60% lecture, 40% hands on labs)

PowerCenter 9.x: Operations and Support

Course Overview

This two day, 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.

Objectives

After successfully completing this course, students 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.
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.
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.
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

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

Agenda
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 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 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 4. 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	5. 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 6. 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 7. Recovery Basics Recover a Workflow has that stopped, aborted or terminated Restart a Session Task


Back to Course Overview

QUESTIONS?

Work Email:

First Name:

Last Name:

Company:

Phone:

Country:

Yes, I would like to receive communications from Informatica about products, solutions and events.

Lead Source:

Lead Source Campaign:

Employee Range:

Revenue Range: