title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Advanced Boot Camp for Developers Informatica PowerCenter 9.6.x
Duration
3 Days
Course
INPC-160
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Advanced Boot Camp for Developers Informatica PowerCenter 9.6.x course teaches advanced mapping techniques and performance tuning and provides a thorough review of session partitioning features found in PowerCenter Version 9.6.x. This course builds on the four-day Foundation boot camp course (INPC-155).Objectives
Upon completion of the Advanced Boot Camp for Developers Informatica PowerCenter 9.6.x course, students will be able to:
- Use local variables, pivoting data, and self-joins
- Understand Data validation and error trapping
- Recognize PowerCenter’s architecture
- Identify bottlenecks and use session partitioning
- Review of command line utilities
Audience
- ETL Developer with a previous PowerCenter Experience
Prerequisites
- INPC-155 Boot Camp for Developers Informatica PowerCenter 9.6.x, or equivalent experience
Topics
Day one
Introduction
Mapping Techniques – local variables
Mapping Techniques – Pivoting data
Mapping techniques - self-joins
Mapping Techniques – Lookup Transformation
Lab: Self-join, Dynamic Lookup and Denormalizing
Mapping Techniques – Surrogate Keys
Mapping Techniques – other
Advanced Parameter usage
Day Two
Mapping Templates
Performance Tuning
Day Three
Mapping Templates
Using XML (optional)
Lab: Using XML
Review of command line utilities
- Course objectives
- Using local variables: self and forward references
- Using the Normalizer transformation (level of occurs, generated keys, examples)
- Normalizing flat file outputs
- Denormalizing with unconnected Lookups
- Denormalizing with the Aggregator (conditional clause and local variables)
- Using a Joiner with the sorted input property
- Using dynamic caching
- Pipeline lookups
- Using the Sequence generator transformation
- Using a trigger, GUID or update overrides
- Calling stored procedures
- Transaction Control transformation and commit points
- Transaction scope
- Sharing mapping parameters between sessions
- Slowly changing dimension updates (type 1, 2, 3 and mixed)
- Lab: dimensional updates
- Data validation and error trapping
- Comparing the contents of two tables and extracting differences
- Building parameter files
- Lab: parameter files
- Understanding PowerCenter’s architecture
- Getting baseline numbers
- Using performance counters
- Identifying bottlenecks
- Tuning the target and source components
- Tuning blocking transformations
- Tuning Lookup transformations
- Lab: tuning the mapping
- Tuning the session, caches and memory
- Using session partitioning
- Tuning the workflow
- Running multiple instances of the same workflow
- Running a session or a workflow on a grid
- Lab: session partitioning
- Using PushDown optimization (optional)
- Slowly changing dimension updates (type 1, 2, 3 and mixed)
- Lab: dimensional updates
- Data validation and error trapping
- Comparing the contents of two tables and extracting differences
- Building parameter files
- Lab: parameter files
- Overview
- XML definitions
- Using XML sources and targets
- Using the XML editor
- Midstream XML transformations
- Infacmd
- pmcmd
- pmrep
Related Courses
-
PowerCenter 8.6/9.1 Web Services
INPC-125- Duration: 2 Days
- Delivery Format: Classroom Training, Online Training
- Price: 1,600.00 USD
-
Boot Camp for Developers Informatica PowerCenter 8.6/9.1
INPC-130- Duration: 4 Days
- Delivery Format: Classroom Training
- Price: 3,200.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.