Informatica PowerCenter for Production Support Version 8.1 Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

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.

Informatica PowerCenter for Production Support Version 8.1 Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology