Informatica PowerCenter 10x for Administrators

Course Code: TTINFADM3

Skill Level: Introductory

Duration: 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.

Introduction

Architecture & Components

Architecture
Components

Managing Domains & Nodes

Installation
Admin Console
Nodes
Licenses
Logging
Reporting

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

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

PowerCenter Repositories

Folders & Sharing
Connections
Exercise #8 Setting Privileges and Permissions
Query tool
Exercise #9 Using the Query Tool
Schema

PowerCenter Command Line Utilities

Pmrep
Exercise #10 Object Export and Import via XML
Pmcmd
Pmpasswd
Pmmetrics

High Availability

Overview
Resiliency
Restart & Failover
Recovery

Performance Tuning

Overview
Mappings
Sessions
Exercise #11 Lookup Cache Optimization
Partitioning
Workflows
Grids

Metadata Deployment

Options
Repository
Folders
Deployment Groups
Objects

Versioning

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

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 December 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

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

Instructor was beyond phenomenal. He had an in depth knowledge of the course material and always ensured that everyone understood what was being discussed. I really enjoyed the mix of theory and practical examples of each part of the course.

Cillian M

Excellent training. Even though it was online, I did not have any issues understanding or getting the answers for the questions I had. The lab exercises are interesting to apply what was learnt. Overall very good training. Thank you!

Anitha

Excellent detail about the Spring framework which directly relates to my role as a senior engineer. I found the content and style to be very enjoyable, and would encourage me to ask questions where previously I might not have paid much attention, eg. pom version numbers / spring starters being imported. The focus on the different styles of unit testing was also excellent and I would plan to incorporate in day to day work.

Edward K

Both the instructor and the course material were very thorough - the course material has many helpful references - the labs were well laid out, making it easy to learn from and get done on time

Steve C.

Great job overall. Great communicator and explained complex concepts in a simple, easier to understand format.

Jeremy G

A very good balance of teaching time to lab time. I've done other courses that I found to be much lighter on content and heavy on labs to waste time. This was a refreshing change of pace.

Adam G

Best programming class I've ever been in, head and shoulders above any thing I took in college as part of a computer science degree. The instructor was thorough and very detailed, he was very good abut explaining all possible scenarios a situation would apply to. The way the albs were structured and the class was conducted was very good for interaction and hand on learning.

Danish J

The instructor was clearly knowledgeable about Java and programming in general. He was very attentive to every student's individual needs and constantly encouraged questions, concerns, student issues to be raised and addressed each one thoroughly.

Mark M

First time in my life I have attended remote class and I find it great. Personally I don't feel there is any area which require improvement!

Rishi M

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More