Informatica PowerCenter for Production Support Version 8.1 Course

Course Code: RT 497
Course Abstract: This course is designed to introduce PowerCenter 8.1 to production support engineers. The class comprises a thorough review of PowerCenter 8.1 architecture, in-depth look at the administration console, Workflow Manager, Workflow Monitor and log events. The course also includes an introduction to PowerCenter basic concepts such as mappings, debugging and the Designer tool in general.
Audience: This course is designed for PowerCenter administrators and production support engineers.
Duration: 3 days
Learning Outcomes: Upon completion of this course, the participant will be able to:
> Manage domains and nodes
> Manage the repository
> Source and target definitions
> Setting breakpoints, changing data, evaluating expressions
> Starting a Workflow
> Using session and workflow properties
> Creating with and without wizard
> Target bottlenecks, common problems and solutions
> Workflow tuning, monitoring performance, workflows on a grid
> Purging object versions, with lists or criteria
Course Topics:

Architecture Overview and Components
V8 service architecture promoting scalability and high availability
Domains, nodes and services

Administration Console
Managing domains & nodes
Adding and configuring application services
Managing console users
Managing Logs

Labs: viewing logs in the console

Command line utilities
Infasetup, managing the domain configuration
Infacmd, managing domain, nodes and services
Pmcmd, managing jobs
Pmrep, managing the repository

Labs: retrieve session and workflow data from the command line

Designer
Development lifecycle
Demo: building and debugging a simple mapping
Tool overview

Concepts
Source and target definitions
Mappings
Transformations

Overview of Primary Transformations
Source Qualifier
Expression
Filter
Aggregator
Joiner
Lookup
Router

Working with Flat Files

Demo: using transformations in a mapping

Working with the debugger
Setting breakpoints, changing data, evaluating expressions
Session log files

Using Local Variables
Self and forward references
Port evaluation

Overview of Secondary Transformations
Stored Procedure
Sorter
Rank
Union
Normalizer
Update Strategy
Sequence Generator

Other Designer Features
Online help
Built-in functions
User defined functions
Mapplets and reusability

Demo: putting in all together in a complex mapping

Workflow Manager
Overview
Interface

Simple Workflows
Session settings
Starting a Workflow

Workflow Monitor
Interface
Gantt chart and task view
Using session and workflow properties
Using session and workflow log events

Workflow Error Handling
Session level
Workflow level
Link conditions

Lab: simple workflow

Complex Workflows
Creating with and without wizard
Reusability

Other Workflow Features
Flat file commands
Workflow tasks and worklets

Lab: complex workflow

Parameters and Variables 
Overview
Parameter files
Using in mappings, sessions and workflows

Performance Tuning [optional]
Benchmarks and performance data
Guidelines
Target bottlenecks, common problems and solutions
Source bottlenecks, common problems and solutions
Mapping bottlenecks, blocking transformations, lookups, non-blocking transformations
Session tuning, memory allocation, monitoring performance, caches
Session partitioning, sessions on a grid
Workflow tuning, monitoring performance, workflows on a grid

Versioning [optional]
Background
Check-in, check-out
Version history, comparing object versions
Labels
Purging object versions, with lists or criteria
Repository queries
Deleting objects

Labs: purging object versions, restoring deleted objects

Prerequisites: Previous PowerCenter experience is required.
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning