Informatica Powercenter Advanced 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 456
Course Abstract:	This course teaches advanced mapping techniques and performance tuning and provides a thorough review of session partitioning features found in PowerCenter version 8.1. This course builds on the four-day foundation course.
Audience:	This course is designed for PowerCenter developers with six months to one year of experience.
Duration:	3 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Apply advanced mapping techniques > Utilize performance tuning techniques
Course Topics:	Introduction Course Objectives Using XML (optional) Overview XML definitions Using XML sources and targets Using the XML editor Midstream XML transformations Lab Mapping Techniques – local variables Using local variables: self and forward references Lab Mapping Techniques – pivoting data Using the Normalizer transformation (level of occurs, generated keys, examples) Using XML normalized source qualifiers (optional) Normalizing flat file outputs Denormalizing with unconnected Lookups Denormalizing with the Aggregator (conditional clause and local variables) Creating XML denormalized views with the pivot feature (optional) Lab Mapping Techniques – self-joins Using a Joiner with the sorted input property Mapping Techniques – Lookup Transformation Using dynamic caching Sharing caches Lab Mapping Techniques – surrogate keys Using the Sequence generator transformation Using an update override to call a database function Mapping Techniques – functions Using pattern matching functions Using hash functions Using user-defined functions Lab Mapping Techniques – other Calling stored procedures Transaction Control transformation and commit points Transaction scope Java transformation overview Union transformation Lab Parameters and Variables Mapping parameters and parameter files Mapping variables Session variables Server process variable Lab Mapping Templates Slowly changing dimension updates (type 1, 2, 3 and mixed) Data validation and error trapping Comparing the contents of two tables and extracting differences Debugger Tips Evaluating expressions Discarding versus not discarding data Workflow Techniques Tasks, links and expressions Using the system command input and output type Reusable sessions Understanding session log files Error handling Performance Tuning Understanding PowerCenter’s architecture Getting baseline numbers Using performance counters Identifying bottlenecks Tuning the target and source components Tuning blocking transformations Tuning Lookup transformations Tuning the session, caches and memory Using session partitioning Tuning the workflow Lab Review of command line utilities pmcmd pmrep Scripting with PowerCenter
Prerequisites:	The Informatica Foundation Bootcamp is required before taking this course.

Informatica Powercenter Advanced 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