Informatica PowerCenter Administration training is an intensive training covering : Informatica architecture, installing the platform, configuring add and manage services, and platform best practices for users, groups, privileges, roles, and permissions. Additional topics include backing up and migration of the Informatica domain database, implementing repository metadata reporting, using the command line, and setting up Reference Table management.
Preview
By the end of this training you will learn to:
Describe the Informatica technical architecture
Describe the Informatica domain, nodes, and application services
Describe the Informatica clients
Configure an Informatica HF1 environment using recognized Best Practices
Install Informatica domain
Describe the Administration Console
Create Privileges and Roles
Describe Informatica permissions
Describe PowerCenter repositories
Describe PowerCenter Web Hub and service
Deploy PowerCenter metadata from development to test environment
Describe Command Line programs
Describe Subject Area Implementation
Describe Metadata Reporting
Describe Reference Table Management
Describe Domain Management
Describe License Administration
Course Contents
Day 1
Domain Architecture
Describe the Informatica technical architecture
Describe the Informatica Domain, Nodes, and
application services
Describe the Informatica clients
Best Practices
Enable Hierarchy Manager for an MDM Operational Reference Store
Configure an Informatica HF1 environment using recognized Best Practices Entities and Entity Types
Installing Informatica
Install Informatica domain
Install Informatica clients
Install Informatica HotFix
Day 2
Configuring PowerCenter Services
Describe the Administration Console
Create PowerCenter Repositories
Create and enable PowerCenter Integration Services
Create and configure domain folders
Security: Users and Groups
Describe the Administration Console
Create Users and Groups
Assign Users to Groups
Security: Privileges and Roles
Create Privileges and Roles
Assign Privileges and Roles to Users and Groups
Day 3
Security: Permissions
Describe Informatica Permissions
Grant Permissions to objects
Describe Administrator Folder Management
Describe Informatica OS Profiles
PowerCenter Repository and Client Applications Management
Describe the PowerCenter repositories
Describe PowerCenter Clients and objects
Web Hub Service Management
Describe PowerCenter Web Hub and service
Create and configure a PowerCenter Web Hub service
Day 4
PowerCenter Repository Metadata
Deployment
Deploy PowerCenter metadata from development to test environment
Deploy PowerCenter metadata across domains to production environment
Command Line Programs
Apply infacmd to domain objects and security
Apply infasetup to domain objects
Apply pmcmd to execute and control workflows
Apply pmrep to manage the PowerCenter Repository
Subject Area Implementation
Describe a Subject Area
Implement a Subject Area into the PowerCenter architecture
Day 5
Metadata Reporting
View PowerCenter operational information via the Metadata Exchange (MX) views and Data Analyzer
Create and configure a PowerCenter Reporting Service (Data Analyzer)
Describe the purpose of Data Analyzer
Reference Table Management
Describe Informatica Reference Tables
Create the Reference Table management environment and edit a reference table
Create a Model Repository Service, Data Integration Service, and an Analyst Service
Import and edit a reference table via the Developer client
Domain Management
Describe Domain Alerts
Describe SMTP settings
Move an Informatica Domain from one database to another
License Administration
Describe the License service
Describe license validation
Apply an incremental license