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.
Informatica PowerCenter 10.5x Advanced Boot Camp for Developers
Duration
3 Days
Course
INPC-200
Available Formats
Classroom Training, Online Training
Course Description
Overview
Our Boot Camp Teaches Advanced Mapping techniques with a primary focus on Performance & Tuning. It offers a thorough review of session partitioning and Push Down optimization in addition to creating mappings from SQL. Slowly Changing Dimensions Mappings for type 1, 2, 3 and 6 are included with innovative techniques.This Boot Camp is a must for all new and experienced Informatica PowerCenter Developers and Administrators. It builds on the four-day Foundation boot camp course (INPC-195) and has many challenging labs to reinforce the knowledge and Techniques of attendees.
Objectives
Audience
- ETL Developer with a previous PowerCenter Experience
Prerequisites
- INPC-195 Boot Camp for Developers Informatica PowerCenter 9.6.x, or equivalent experience
Topics
- Course objectives
- Using local variables: self and forward references
- Using the Normalizer transformation (level of occurs, generated keys, examples)
- Normalizing flat file outputs
- De-normalizing with unconnected Lookups
- De-normalizing with the Aggregator (conditional clause and local variables)
- Using a Joiner with the sorted input property
- Using dynamic caching
- Pipeline lookups
- Lab: Self-join, Dynamic Lookup and De-snormalizing
- Using the Sequence generator transformation
- Using a trigger, GUID or update overrides
- Calling stored procedures
- Transaction Control transformation and commit points
- Transaction scope
- 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
- 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)
- Overview
- XML definitions
- Using XML sources and targets
- Using the XML editor
- Midstream XML transformations
- Lab: Using XML
- Infacmd
- pmcmd
- pmrep
Related Courses
-
Informatica PowerCenter v10.5x Foundation Boot Camp for Developers
INPC-195- Duration: 4 Days
- Delivery Format: Classroom Training, Online Training
- Price: ???
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.