Informatica PowerCenter 10 Developer Level 2


Target audience:
Database Developers with six months or more experience with PowerCenter Prerequisites: - PowerCenter 9.x/10 Level 1 Developer - 3 Months or more experience working with PowerCenter.

Prerequisites:
PowerCenter 9.x/10 Level 1 Developer - 3 Months or more experience working with PowerCenter.

Description:
PowerCenter 10: Developer, Level 2 complements and extends the PowerCenter 10: Developer, Level 1 class with advanced topics and extended labs. This course can be delivered through a four-day instructor led format or through our onDemand offering, which is comprised of 13 modules and 10 labs.

Content:
The course content includes the following topics:
  • Informatica PowerCenter architecture.
  • User defined and advanced functions.
  • Use of Mapping Variables and Parameter Files.
  • How to Normalize and Denormalize data using PowerCenter.
  • The Stored Procedure transformation and its two modes of use.
  • The SQL Transformation.
  • PowerCenter source-based, target-based, and user-based transaction control.
  • Constraint-based loading.
  • The Transaction Control transformation for data-driven transaction control.
  • Built-in, optional, and mapping design recovery capabilities.
  • Built-in and optional High Availability functions.
  • PMCMD and PMREP command-line functionality.
  • PowerCenter Performance Tuning Methodology including performance counters, thread utilization, source, target, and integration service bottlenecks, and the impact of the update-else-insert setting.
  • Effect of mapping design on performance.
  • Apply design principles by building a new mapping.
  • Effect of caching and RAM on performance.
  • The transformations that cache data, the DTM buffer pool, and the use of cache calculators.
  • PowerCenter Partitioning rules, types and effect on the DTM buffer pool.


General information:

GENERAL

The course is taught in local language, the course material is written in English. Course includes plenty of hands-on exercises.

Course price includes course material and catering (coffees, lunch) daily.

Affecto reserves the right to make changes to courses and schedules. Affecto may cancel a course if there are less than six (6) participants. Affecto is not responsible for any expenses related to course cancellation.

This course can also be arranged onsite at customer location.

FINLAND
The course will be held Affecto Academy training facility at Atomitie 2, 00370 Helsinki. The course day begins at 9am and end at 4pm.

VAT will be added to the prices.

For more information, please contact Academy Finland

NORWAY
The course will be held Affecto Academy training facility at Stortorvet 10 (GlasMagasinet), Oslo. The course day begins at 9am and end at 4pm.

For more information, please contact Academy Norway

SWEDEN
The course will be held at either Affecto Academys training facility at Holländargatan 17B, 111 60 Stockholm or at an external training facility in Stockholm depending on the number of participants. The course day begins at 9am and end at 4pm.

VAT will be added to the prices.

For more information, please contact Academy Sweden



Duration: 4 day
Price: 2800.00 €

Register:
07.11.2017, Affecto Finland

Cancellation and payment terms
Request offer
Print
Good to know
Contact
Calendar