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
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
