Sweden path Tjänster path Utbildning: Affecto Academy path Kurskalender path Informatica path Informatica PowerCenter 9.x Level 2 Developer

Informatica PowerCenter 9.x Level 2 Developer

Tillbaka
Anmälan
Varaktighet 3 dagar

This three-day, instructor-led course complements and extends “PowerCenter 9x Level One Developer” with advanced topics and extended labs. The course is intended for developers with more than six months of PowerCenter 9 experience. Topics covered include: High Availability, Pipeline Lookup and Dynamic Lookup expressions, the SQL transformation, and the Transaction Control transformation.  Additional topics include extended use of parameter files, pivoting data, session and workflow recovery, use of command line utilities, and Mapping Architect for Visio.  The course includes an extensive series of performance tuning workshops that include methodology, mapping design, and cache management with memory optimization.

Course Venue
Stockholm
Målgrupp

Database developers with six months or more experience with PowerCenter
Specifika önskemål
  • PowerCenter Developers with one year or more of professional experience
  • Completion of Informatica PowerCenter Level 1 Developer training class
Innehåll

After successfully completing this course, students should be able to:

  • Describe the Informatica PowerCenter architecture
  • Describe user defined and advanced functions
  • Describe how to Normalize and Denormalize data using PowerCenter
  • Describe the Stored Procedure transformation and its two modes of use
  • Describe the SQL Transformation
  • Describe PowerCenter source-based, target-based, and user-based transaction control
  • Describe constraint-based loading
  • Describe the Transaction Control transformation for data-driven transaction control. 
  • Describe built-in, optional, and mapping design recovery capabilities
  • Describe built-in and optional High Availability functions
  • Describe PMCMD and PMREP command-line functionality
  • Describe PowerCenter Performance Tuning Methodology including performance counters, thread utilization, source, target, and integration service bottlenecks, and the impact of the update-else-insert setting.
  • Describe the effect of mapping design on performance.
  • Apply these design principles by building a new mapping.
  • Describe the effect of caching and RAM on performance.
  • Describe the transformations that cache data, the DTM buffer pool, and the use of cache calculators.
  • Describe PowerCenter Partitioning rules, types and effect on the DTM buffer pool.
Datum Will be arranged if there is enough interest
Tillbaka
Anmälan