Informatica PowerCenter 10x for Administrators

Informatica PowerCenter 10x for Administrators



3 Days

Course Overview

Geared for ETL Administrators new to Informatica, Informatica PowerCenter 10x for Administrators focuses on the architecture, administration console, grids and high availability features of version Informatica PowerCenter version 10.x. 

Course Objectives

Working in a hands-on learning environment led by our expert practitioner, attendees will explore:

  • Informatica Overview, Architecture & Components
  • Managing Domains & Nodes
  • Managing PowerCenter Services
  • Domain Security
  • PowerCenter Repositories
  • PowerCenter Command Line Utilities
  • High Availability
  • Performance Tuning
  • Metadata Deployment
  • Versioning
  • PowerExchange Overview

Course Prerequisites

This course is geared for ETL Administrators with no prior Informatica experience. 

Course Agenda

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most.



  1. Introduction


  1. Architecture & Components
  • Architecture
  • Components


  1. Managing Domains & Nodes
  • Installation
  • Admin Console
  • Nodes
  • Licenses
  • Logging
  • Reporting


  1. Managing PowerCenter Services
  • Repository
  • Exercise #1 Creating Repository Service
  • Exercise #2 Restoring a Repository from a Backup
  • Integration
  • Web hub
  • Other Services
  • Exercise #3 Creating an integration service
  • Exercise #4 Viewing Domain and Service Logs


  1. Domain Security
  • Users & Groups
  • Exercise #5 Creating Administrator user Accounts
  • Privileges & Roles
  • Permissions
  • Exercise #6 Creating a Domain Folder
  • Exercise #7 Backing up the Domain Configuration


  1.   PowerCenter Repositories
  • Folders & Sharing
  • Connections
  • Exercise #8 Setting Privileges and Permissions
  • Query tool
  • Exercise #9 Using the Query Tool
  • Schema


  1. PowerCenter Command Line Utilities
  • Pmrep
  • Exercise #10 Object Export and Import via XML
  • Pmcmd
  • Pmpasswd
  • Pmmetrics


  1. High Availability
  • Overview
  • Resiliency
  • Restart & Failover
  • Recovery


  1. Performance Tuning
  • Overview
  • Mappings
  • Sessions
  • Exercise #11 Lookup Cache Optimization
  • Partitioning
  • Workflows
  • Grids


  1. Metadata Deployment
  • Options
  • Repository
  • Folders
  • Deployment Groups
  • Objects


  1. Versioning
  • Check out / Check in
  • History
  • Labels
  • Find Checkout
  • Deleting
  • Exercise #12 Restoring Deleted Objects
  • Purging
  • Exercise #13 Purging Old Objects Versions


  1. PowerExchange Overview
  • PWX Functionality
  • PWX Benefits
  • PWX Architecture, and Configuration

Course Materials

Each student will receive a Student Guide with course notes, code samples, software tutorials, diagrams and related reference materials and links (as applicable). Our courses also include step by step hands-on lab instructions and and solutions, clearly illustrated for users to complete hands-on work in class, and to revisit to review or refresh skills at any time. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Mix, Match & Master!
2FOR1: Two Courses, One Price!

Enroll in *any* two public courses (for 2023 *OR* 2024 dates!) by October 31, for one price!  Learn something new, or share the promo!

Click for Details & Additional Offers

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More