Home | Services | Education
Informatica PowerMart / PowerCenter 6
- Advanced Administrator
Description
This course is intended for Informatica administrators and/or developers with more than six months of PowerMart / PowerCenter experience and will be performing Informatica Administrator tasks.
Duration: 4 days
Format: Instructor-led
Location: Info-Alchemy Training Center and on-site
Audience: PowerMart / PowerCenter administrators and/or developers
Pre-requisites: A minimum of six months experience with PowerMart / PowerCenter 6 Agenda
Day One
Introduction
* Introduction and Overview of Advanced class
Module: Advanced Workflow Techniques
Advanced Workflow Techniques Overview
* Workflow Manager
* Workflow Technique Topics
Reusable Special Objects
* Scheduler
* Session Configuration
Lab WT1 – Use a Wizard to Create Multiple Sequential Workflows
Lab WT2 – Reusable Schedule for a Workflow
Lab WT3 – Reusable Configuration for a Workflow
Reusable Tasks
* Task Designer properties
* E-mail, Command and Session Task Properties
Non-reusable Tasks
* Overview of non-reusable tasks
* Non-reusable Task properties
Lab WT4 – Session Configuration Object, Command Task & File List
Worklets
* Worklet Designer
* Reusable and Non-reusable Worklets
* Worklet limitations
Lab WT5 – Create Worklets Using Tasks
Lab WT6 – Event Wait with Pre Defined Event
Lab WT7 – User Defined Event, Event Raise and Event Wait
Lab WT8 – Assignment Task & Workflow Variable
Day Two
Module: Performance Tuning
Performance Tuning Methodology Overview
* Performance Tuning Topics
* Overview of the System Environment
Measuring Performance and Establishing Baselines
* Identifying Bottlenecks
* Monitoring External Processes
* Network and ETL Baselines
* Server Architecture
Lab PT1 – Establishing Baselines and Partitioning by Flat Files
Partitioning
* Enhanced Data Parallelism
* Repartitioning Points
Lab PT2 – Partition Points
Identify Bottlenecks
* Identifying Source, Target, Mapping and Session Bottlenecks
Lab PT3 – Oracle Loader
Optimization Methodology to Tune Informatica Components
* Mapping and Sessions Optimization
* Calculating Cache Sizes
* Named versus Unnamed Lookup Caches
Lab PT4 – Persistent named Lookup Cache
PMCMD Features
* Overview of PMCMD and functions
Lab PT5 – PMCMD in Interactive and Command Line Mode
Day Three
Module: Security and Basic Administration
Overview of Basic Administration
* Basic Security Tasks
* Basic Folder Administration
Lab SA1 – Security and Administration
Module: Repository Manager and Repository
Administration
Overview of Basic Administration with Repository
* Console Administration
* Repository Manager Administration
* Dependency Analysis
* Session Analysis
Lab RM1 – Repository Manager and Designer Dependency Reports
Lab RM2 – Repository Manager Features and Techniques
Lab RM3 – PMREP and other Repository Console Topics
Module: Workflow Manager and Workflow Monitor
Administration
Overview of Workflow Manager and Workflow Monitor
* Workflow Manager Administration Topics
* Reusable Object privileges and maintenance
* Workflow Maintenance
Lab WM1 – Workflow Manager Connections and Privileges
Lab WM2 – Reusable Objects in Workflow Manager
Lab WM3 – Workflow Monitor Features
Day Four
Module: Migration
Overview of Migration Strategies
* Migration Strategies for One Repository
* Migration Strategies for Multiple Repository
Lab MI1 – Migrate within One Repository from Dev to Test Lab MI2 – Migrate Across Repositories From Test to QA Lab MI3 – Backup and Restore Repository from QA to Prod
Module: Metadata Reporting
Overview of Metadata Reporting
* Metadata Reporter
* MX view reporting
Lab MR1 – Metadata Reporting with Metadata Reporter
Lab MR2 – Metadata Reporting with MX Views
Module: Velocity Methodology Presentation
Overview of Velocity
* Velocity Phases
* Velocity Best Practices
* Velocity Deliverables
Lab VM1 – Naming Conventions
Lab VM2 – Mapping Documentation
-------------------------------------------------------------------------
To register for a class, contact Info-Alchemy Education Services through our email at education@info-alchemy.com for additional information.
|
