Informatica Power Center 8.6 Level-2 Developer

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

Transformations

• 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