Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Informatica Administration 9x/10x
Introduction
Welcome and Thank you for taking this course with me!!
Introduction & Overview (20:17)
Getting Started/ ETL Overview (19:50)
Power Center Architecture
Informatica Domain Architecture (19:48)
Informatica Nodes/Core Services/Gateway Nodes (18:33)
Types of Nodes, Common Issues and Troubleshooting (20:14)
Informatica version 9.6 - Installation and Configuraton
Pre Installation Steps & System Pre-Requisites (19:18)
Quick Tip: Product Availability Matrix - PAM (8:02)
Download Software (9:24)
How to extract the downloaded Informatica files? (2:24)
PowerCenter Server Installation (17:10)
Power Center Client Installation (2:30)
Informatica version 9.6 - Administration Console
Introduction to the Administration Console (12:59)
List of Services
Deep dive of the Domain Properties - Part 1 (19:46)
Deep dive of the Domain Properties - Part 2 (3:33)
Node Properties (9:30)
Setting up Repository Service (18:30)
Repository Service Properties (29:28)
Setting up Integration Service (18:18)
Integration Service properties (15:40)
Start and Stopping the services (19:01)
Starting and Stopping of Services - IDQ (8:24)
Informatica Version 10 - Installation and Configuration
Server Client Installation - Part 1 (12:26)
Server Client Installation - Part 2 (10:57)
Informatica 10 - Administrator Console
Admin Console New Features (8:39)
Step by Step process on what properties to choose for creating the Repository Service. (8:59)
Integration Service Creation (3:17)
Informatica Security
What is Informatica Security? (9:42)
How to perform the LDAP SetUp in Informatica? (13:41)
What are the different Roles in a Project and how to enable and disable access to the users? (9:43)
Binding a Native User to a Relational Connection (6:17)
Handout on How to configure LDAP
IDQ (Informatica Data Quality) Services
IDQ DataSheet
IDQ MRS (Model Repository Service) Creation (17:42)
IDQ MRS (Model Repository Service) Properties (12:12)
IDQ DIS (Data Integration Service) Creation and Properties - Part 1 (20:15)
IDQ DIS (Data Integration Service) Properties - Part 2 (11:12)
IDQ Analyst Service (4:49)
IDQ Content Management Service (3:53)
Web Services
Steps to create and configure the Web Services and Properties (12:24)
How to use the Web Services Try It Application? (13:04)
High Availability
What is High Availability? (9:44)
What are the features of High Availability and how to configure it? (17:08)
Handouts for more information on High Availability
Grids
What is a GRID Computing and how does it work? (12:47)
How to identify if GRID setup is required for your environment? (5:04)
What are the pre-requisites to configure the Grid for your environment? (6:40)
01 Configuration Steps 1 (11:39)
02 Resource Configuration (1:45)
03 IS Resource Configuration (1:45)
04 Disabling Connection Resources (2:02)
05 Load Balance Options (10:47)
What are different Service Levels and How to configure them? (17:26)
Dev Activities (WONG & SONG) (12:20)
Dev Activities - High Availability and Recovery Stratergy (11:45)
Frequently Asked Questions on GRID
Additional Resources and How to Guides
Operating System Profiles
Operating System Profiles - Part 1 (19:59)
Operating System Profiles - Part 2 (13:23)
OS Profile commands to use in UNIX
License Management
License Management (18:01)
Types of License (14:39)
Client Tools and Sample WorkFlow Creation
Repository Configuration and Folder Creation (13:15)
Basic File directory structures (12:21)
Client Tools and Components (12:54)
Repository Manager Activities (7:25)
Transformations Overview (20:39)
Mapplet (17:10)
Usage of Debugger (17:29)
Informatica PowerCenter Monitor & Repository Manager for Log Information
Monitor Tool's functionality & Available Options (17:29)
How to analyze the log information from the sessions? (6:56)
Versioning
Version Control (19:39)
Steps to purge the older versions of the objects (15:37)
Handout for additional information on purging
Migration/Deployment Strategies
Static and Dynamic Deloyment Groups (10:30)
Deploying via XML (16:32)
Folder Copy from One Repository to Another Repository (7:39)
Manual Object Copying (4:20)
Team Based Deployment FAQs
Repository Metadata
Repository Metadata Tables and Queries - Part 1 (19:24)
Repository Metadata Tables and Queries - Part 2 (20:56)
Hand Out with Commonly used Repository Queries
Repository BackUps and Snapshots
Repository Maintenance Introduction (2:58)
How to Backup the Repository? (4:21)
How to view the list of Repository Back Up files? (0:35)
How to restore the repository from back Up files? (5:54)
How to manage the versioned repository? (1:36)
How to manage the folders using the Repository Manager? (0:19)
Tips on Log Management (1:36)
Performing the Database Stats on the Repository Database (2:43)
Final review of all the topics covered (2:10)
Version Upgrades
Pre and Post Upgrade Checklists (7:44)
Object Inventory, Environment Details, Upgrade Checklist
Informatica 10
Upgrade Planner for Informatica 10.0 (6:21)
Version 10 New Features (11:58)
Admin Console New Features (8:39)
Steps to un-install Informatica 10 from Windows machine (6:24)
Final review of all the topics covered
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock