Prerequisites:

• Knowledge in SQL
• General relational database (Oracle)
• Microsoft Windows GUI, Windows Command line, General programming
• Basic UNIX commands

Module 0: Introduction & Module 1: Domain Architecture

• Understanding Domains and Nodes and grids.
• Domain Management
• Domain tab, Logs tab, Reports tab, Monitoring and security tab

Module 2 : Best Practices & Module 3 : Installing Informatica 9

• Instillation Informatica Clients
• Installation Informatica in Windows
• Installation of Informatica in Linux

Module 4 : Configuring PowerCenter 9.x Services

• Analyst Service
• Power center Repository Service
• Power Center integration Service
• Model repository service
• Data Integration Service
• Content Management Service
• Power Exchange Listener Service
• Power Center Logger Service
• Web Services Hub
• Reporting Service
• Reporting and Dashboards
• SAP BW Service.
• Monitoring Services
• Start and Stop Services

Module 5 : Security Management in Informatica

• Create Users, Groups, Roles
• Assigning roles to user
• Assigning privileges to user
• Enable user access
• Disable user access
• LDAP Authentication

Module 6: PowerCenter Repository and Client Applications Management

• Connection Management
• Folder Maintenance

Module 7 : PowerCenter Repository Metadata Deployment

• Repository and Object Migration
• Deploying via XML
• Folder Copy
• Developing Deployment Groups
• Managing Versions ,Labels
• Administration of Shortcuts, and Reusable Objects

Module 8 : Command Line Programs

• pmcmd, pmrep, infacmd
• Creating users using shell script
• Automation of Domain and Repository activities
• Start and Stop workflows using command line utilities

• Module 09 : Metadata Reporting
• Module 10 : Reference Table Management
• Module 11 : License Administration