TrainOvation




Expert Online Informatica Training via High Quality Streaming Video
Sign In / Create Login


Course Outline

Informatica PowerCenter Introduction & Basics

This comprehensive course covers the fundamentals including:

What is Informatica? How does it work? How do I work with it?


  • Apply Informatica for Transformations & Data Integration
  • Design Efficient Mappings, Sessions and Workflows
  • Understand how to Build, Debug and Optimize Mappings

This course covers Informatica from top to bottom in the core architecture of the product. The instructor will take the student through the architectural components, the Designer, Workflow Manager, Workflow Monitor, Repository Manager, and server configurations and setup. It will cover basic concepts about mapping design, workflow design, and process monitoring. During the class, the student will learn about each of the transformation objects, what they are for, and how they might be used to solve specific business problems. This course is equivalent (in agenda only) to Informatica PowerCenter Level 1 Developer.


*** This course is CUSTOM BUILT by Dan Linstedt and takes you far beyond Informatica's standard training materials. It covers concepts not found in user manuals, blogs, or anywhere else!





Course Outline

Informatica Advanced Performance & Tuning

This course presents Informatica Advanced Performance and Tuning topics including parallelism, partitioning, complex design approaches, and huge volume processing. The instructor dives deep into advanced settings for optimal performance.


  • Reduce Mapping Complexities
  • Establish Metrics and Apply Powerful Performance Techniques
  • Master Partitioning, Session Settings and Parallelism
  • Discover the Speeds Your Sessions SHOULD be Running

The focus of this class is to experience, walk through, learn and engage with advanced settings, complex versus simple designs, and how they impact system performance. This class will take the student through the information necessary to enable processing at speeds of 80,000 rows per second and above. In this class, we touch on everything from mapping designs to database impacts, to row and column sizes. We delve into database settings, parallel queries, and finding and solving performance problems that are otherwise missed. During the class the student will learn about the differences between auto-memory management and managed memory settings, scheduling conflicts and too much (over) parallelism. This class also covers information about memory, disk, hardware, CPU, over-utilization, and performance baseline measurement.


Techniques taught in this course provide performance improvements from 400% to 4000%. These techniques can reduce 4 hour run times to under 30 minutes (and 2 hour run times down to 20 minutes, and 12 hour run times to 1.5 hours). Register today to find out how to really make your Informatica sessions hum.


*** This course is CUSTOM BUILT by Dan Linstedt and takes you far beyond Informatica's standard training materials. It covers concepts not found in user manuals, blogs, or anywhere else!