- Introduction & Overview
- Getting Started/ ETL Overview
Informatica Power Center Administration
Quick Facts
particular | details | |||
---|---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
The administrative processes for object classes like applications, interconnections, and licenses are consolidated by the application client called Informatica Powercenter. The Informatica Power Center Administration online certification was designed by Sid Inf - Data & ETL Architect and is provided by Udemy, which is meant for participants who wish to learn the most recent Informatica features and techniques related to updates to the administration console.
Informatica Power Center Administration online course focuses on assisting the participants in learning the procedures required to manage the Informatica architecture and discusses fundamental to advanced concepts of management of the Informatica environment. Informatica Power Center Administration online classes topics like cover Informatica administration, repository maintenance, grid management, scheduling, and version control as well as discuss the techniques for repository migration, importing or exporting metadata level.
The highlights
- Certificate of completion
- Self-paced course
- 17 hours of pre-recorded video content
- 8 downloadable resources
Program offerings
- Online course
- Learning resources
- 30-day money-back guarantee
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
certificate availability
Yes
certificate providing authority
Udemy
Who it is for
What you will learn
After completing the Informatica Power Center Administration certification course, participants will acquire gain a hands-on experience of the fundamentals involved with Informatica PowerCenter as well as will acquire knowledge of Informatica architecture. Participants will explore the fundamentals of Informatica PowerCenter administration as well as will acquire the functionalities of the administration console. Participants will learn about strategies associated with license management, repository management, grid management, scheduling, version control, and high availability. Participants will also acquire the skills for working with IDQ services, web services, repository metadata, Informatica security, migration, and deployment.
The syllabus
Introduction
Power Center Architecture
- Informatica Power Center version 9.6 - New Features
- Informatica Domain Architecture
- Informatica Nodes/Core Services/Gateway Nodes
- Types of Nodes, Common Issues and Troubleshooting
- Hand out for Section 2
Installation and Configuration on Windows
- Pre Installation Steps & System Pre-Requisites
- Quick Tip: Product Availability Matrix - PAM
- Download Software
- Too Many Files!! Which files to downlaod?
- Oracle 11g Installation and SQL Developer Configuration
- Downloaded Files - Extraction Procedure
- PowerCenter Server Installation
- Power Center Client Installation
Informatica Power Center 10.2 Server Installation on LINUX
- Quick Overview on Pre-Requisites of Informatica PowerCenter10.2 Installation
- Informatica Power Center 10.2 Server Installation on LINUX
- Informatica 10.2 Client Installation on Windows
Administration Console
- Administration Console Introduction
- List of Services
- Domain Properties - Part 1
- Domain Properties - Part 2
- Node Properties
- Setting up Repository Service
- Repository Service Properties
- Setting up Integration Service
- Integration Service properties
- Start and Stopping the services
- Starting and Stopping of Services - IDQ
Informatica Security
- Informatica Security Part 1
- LDAP SetUp
- Different Roles in a Project
- Handout for LDAP Configuration
- Binding a Native User to a Relational Connection
IDQ Services
- IDQ DataSheet
- IDQ MRS (Model Repository Service) Creation
- IDQ MRS (Model Repository Service) Properties
- IDQ DIS (Data Integration Service) Creation and Properties 1
- IDQ DIS (Data Integration Service) Properties 2
- IDQ Analyst Service
- IDQ Content Management Service
Web Services
- Web Services Creation and Properties
- Web Services Try It Application
High Availability
- What is it?
- Features & Configuration
- Various Situations and Benefits
Grids
- What is it?
- Is this required for your environment?
- Pre Requisites
- 01 Configuration Steps 1
- 02 Resource Configuration
- 03 IS Resource Configuration
- 04 Disabling Connection Resources
- 05 Load Balance Options
- Service Levels
- Dev Activities (WONG & SONG)
- Dev Activities - High Availability and Recovery Stratergy
- Frequently Asked Questions
- Additional Resources and How to Guides
Operating System Profiles
- Operating System Profiles - Part 1
- Operating System Profiles - Part 2
- Additional Material
License Management
- License Management
- Types of License
Client Tools and Sample WorkFlow Creation
- Repository Configuration and Folder Creation
- Basic File directory structures
- Client Tools and Componenets
- Repository Manager Activities
- Transformations Overview
- Mapplet
- Usage of Debugger
Informatica PowerCenter Monitor & Repository Manager for Log Information
- Monitor Tool's functionality & Available Options
- Session Log
Versioning
- Version Control
- Purging older versions
- Additional Information and Resources
Migration/Deployment Strategies
- Static and Dynamic Deployment Groups
- Deploying via XML
- Folder Copy from One Repository to Another Repository
- Manual Object Copying
- Additional Information and Resources
Repository Metadata
- Repository Metadata Tables and Queries - Part 1
- Repository Metadata Tables and Queries - Part 2
- Hand Out with Commonly used Repository Queries
Repository Maintenance
- What is Repository Maintenance?
- How to Backup the Repository?
- How to view the list of Repository Back Up files?
- How to restore the repository from back Up files?
- How to manage the versioned repository?
- How to manage the folders using the Repository Manager?
- Different aspects of Log Management
- Performing the Database Stats
Version Upgrades
- Pre and Post Upgrade Templates
Informatica 10
- Upgrade Planner for Informatica 10.0
- Informatica 10: New Features
- Informatica 10 -Installation Steps Part 1
- Informatica 10 -Installation Steps Part 2
- Informatica 10 - Administration Console Upgrades
- Informatica 10 - Uninstall Steps - Windows based