Informatica Powercenter Upgrade For Developers Version 7.1 To Version 8.1 Course

Course Code: RT 457
Course Abstract: This course is designed to introduce PowerCenter 8 to developers already familiar with version 7.1.  Major architectural changes are introduced but the focus stays on development tools improvements within the designer, workflow manager and workflow monitor clients. 
Audience: This course is designed for PowerCenter developers with six months to one year of experience with version 7.1.
Duration: 2 days
Learning Outcomes: Upon completion of this course, students will be able to:
>Define domains, nodes and services
>Add a repository
>Build a repository query
>Create User Defined Functions (UDF)
>Create Java transformations
>Define support for XML data types
>Use workflow monitor
Course Topics:

Architecture Review
V8 new service architecture promoting scalability and high availability
Overview of domains, nodes and services

Designer Usability Improvements
New look & feel
Tools and menu changes
Adding a Repository
Autolink improvements
Propagating port descriptions
Using Repository queries

Lab:  building a repository query

Transformation Language Changes
New built-in functions: pattern search, encryption, compression, financial
Using Perl style regular expressions for pattern matching

Lab: using search functions

User-Defined functions (UDF)
Overview
Creating UDF
Using UDF
Sharing UDF

Lab: creating a user defined function

Java Transformation
Overview, architecture and components
Setting up
Editing custom Java code
Callable API
Using expressions
Debugging Java transformations

Lab: creating a Java transformation

Transformations improvements
New data types for flat file sources and targets
Custom Transformation enhancements
Custom expressions API

XML
Support for new data types
Support for XML schema subsets

Workflow Manager
Flat file targets improvements
Flat file commands, FTP file lists
Partitioning improvements: flat files, Oracle target database partitioning

Lab: using flat file commands

Pushdown optimization
Overview
Source, target and full pushdown optimization
Implementing pushdown optimization

Lab: using pushdown optimization

Workflow Monitor
Centralized log server
Using the new log server

Prerequisites: None
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

Testimonials

The instructor was excellent. He did his best working with our local policies preventing some actions from being completed, and had an understanding of our roles and what we were limited to do with his materials.

–Student; Implementing and Administering Windows Vista