Informatica PowerCenter Operations and Support Training

ExistBI is an Informatica Partner

Course Description

This two day PowerCenter Operations and Support instructor-led training 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.

Course Outcomes

At the end of the course, learners will be able to:

  • 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

Course Summary

Next Public Course Dates

UK & Europe:

  • 26 - 27 September 2023
  • 10 - 11 October 2023
  • 24 - 25 October 2023

US & Canada:

  • 3 - 4 October 2023
  • 17 - 18 October 2023
  • 7 - 8 November 2023
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
Duration
  • 2 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • PowerCenter operational support
  • ETL project managers
  • Team Leads

Course Modules

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

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:


Book This Course

Other Training Areas of Interest

Get Notified of Upcoming Classes

Want to know when the next class will be offered? Sign up for notifications!

      To discuss your project requirements, send us a message

        For a free assessment, quick quote or training information, send us a message

          To book this course, please fill in your details and submit the form.

            To book this course, please fill in your details and submit the form.

              To discuss your training requirements or book a class, drop us a line