Informatica PowerCenter: Developer Level 2

  1. Next course On demand
  2. Send inquiry

Explore Informatica PowerCenter 10.0.0 which is comprised of a server and client workbench tools that Developers use to create, execute, monitor and schedule ETL processes.

SUMMARY

This course is applicable to software version 10. Explore Informatica PowerCenter 10.0.0 which is comprised of a server and client workbench tools that Developers use to create, execute, monitor and schedule ETL processes. Work through the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools while performing tasks such as creating source and target definitions, transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data.

OBJECTIVES

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

  • Understand the Informatica PowerCenter architecture
  • Determine the structure and use of PowerCenter Parameter Files
  • Implement user-defined and advanced functions.
  • Normalize and Denormalize data using PowerCenter
  • Use the Lookup transformation in Dynamic mode
  • Call a SQL stored procedure from a PowerCenter mapping
  • Create and configure a SQL transformation and its two modes of use
  • Design error handling strategies appropriate for the intended purpose of a workflow
  • Make use of the PowerCenter source-based, target-based, and user-based transaction control
  • Utilize constraint-based loading in databases with referential integrity constraints
  • Use the Transaction Control transformation for data-driven RDBMS transaction control
  • Determine the proper use of built-in and optional, mapping-design recovery capabilities
  • Build batch files that use PMCMD and PMREP command line programs
  • Apply PowerCenter Performance Tuning Methodology
  • Describe the effect of mapping design on performance and apply these design principles to a mapping
  • Calculate how much memory a session uses and tune session-level memory Apply partitions, distribute the data and optimize the CPU memory usage

AUDIENCE

Developer

PREREQUISITES

  • Understanding of RDBMS concepts
  • Knowledge of SQL
  • PowerCenter: Data Integration for Developers

COURSE CONTENT

  • Module 1: PowerCenter 10 Architecture
  • Module 2: Parameter Files
  • Module 3: User-Defined and Advanced Functions
  • Module 4: Pivoting Data
  • Module 5: Dynamic Lookups
  • Module 6: Stored Procedure and SQL Transformations
  • Module 7: Troubleshooting Methodology and Error Handling
  • Module 8: Transaction Processing
  • Module 9: Transaction Control Transformation
  • Module 10: Recovery
  • Module 11: Command Line Programs
  • Module 12: Performance Tuning Methodology
  • Module 14: Memory Optimization
  • Module 15: Performance Tuning: Pipeline Partitioning

 

Find more about course on Informatica University website



Warning: Creating default object from empty value in /home/customer/www/inteligencija.com/public_html/wp-content/themes/inteligencija/includes/courses.php on line 57

You are interested in this course? Ask us for more info!