Informatica Power Center 8.6 Developer Level-2

Have Queries? Ask us +91 72592 22234

Course Overview

This "Informatica Power Center 8.6" Level 2 Developer course provides the Advance skills and Advance development knowledge to developers who are already worked on Informatica Power Center and need to implement some advance features related to Performance tuning and Special requirements, through lectures and hands-on exercises. In addition to gaining tremendous insight into the Informatica powercenter Development, Participants shall be exposed to "Performance tuning techniques", and some special features of the Tool.

Course Content

Introduction to Informatica Powercenter 8.6
Informatica Architecture in Detail

  • Overview
  • Connectivity
  • Integration/Repository service process
  • Load Balancer
  • Grids /Nodes /Domain
  • Code Pages and Data Movement modes

Use of Informatica Client Tools in Detail and Special Features Available

  • Mapping Designer
    • propagate attributes
    • Introduction to User Defined Functions
    • Introduction to Informatica Functions (SetVariable, Setmaxvariable etc.)
    • Significance of Aggregate Value Port and issues Related with it
    • Introduction to Persistent values and related Issues
  • Create Relational connections.
    • Create Relational connections.
    • Create FTP/SFTP connections.
    • Introduction to External Loader Connections
    • Interchanging Mapping /Workflow Variable values b\w sessions
    • Assign Integration Service to WF's
  • Repository Manager
    • Create Folders/Users/Groups
    • Provide Permissions to Users/Groups
  • Workflow Monitor
    • Session and work flow logs
    • Stop/Abort/Restart WF's
    • Difference between Stop and Abort


  • Look up caches
    • Overview
    • Connected look up caches
    • Persistent look up caches
    • Uncached look up / static cache
    • Sharing the look up cache
  • Dynamic look up cache
    • Overview
    • Properties
    • New look up row
    • Rules and guidelines
    • Example
  • Persistent Lookup Caches
  • Advanced Topics
    • Workflow Scheduler
    • Performance Tuning(Performance tuning of Source ,Target , Mapping and Session)
    • Use of Partitions
    • Introduction and use of Push Down Optimization
    • Debugger
    • Incremental Aggregation
    • Constraint Based Loading v\s Target Load Plan
    • Introduction to High Availability option
    • Workflow Recovery
    • Informatica Wizards for Slowly Changing Dimension Type 1/2/3
    • Informatica Wizard Usage
  • Data warehousing Concepts
    • Introduction to Data Warehousing   
    • Introduction to OLTP, ETL and OLAP Systems
    • Star Schema
    • Snowflake Schema
    • Types of Fact and Dimension Tables

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234