Informatica Power Center Administration

BY
Udemy

Gain a thorough understanding of the strategies of Informatica PowerCenter administration and the methods employed.

Mode

Online

Fees

₹ 2499

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
₹ 2,499
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Database management

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

  • Introduction & Overview
  • Getting Started/ ETL Overview

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

Instructors

Mr Sid Inf
Instructor
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books