Data warehousing concepts

• Introduction to DWH
• Characteristics of DWH
• OLTP/OLAP concepts and differences
• Sample DWH applications
• ETL/Reporting concepts
• Star/Snowflake/Galaxy schema.

Informatica 8.6

• Informatica installation
• Informatica Admin console (user creation/security/access)
• Infomatica client tools (Designer,Worfklow Manager,Workflow monitor,Repository manager)
• Importing source/target definitions
• Creating mappings
• Transformations (Active and Passive) & Reusable Transformations
• Working with transformations on business requirements
• Mappings/Mapplets (Reusable Mapplets)
• Using Store procedure

Workflow Manager

• Creating various tasks
• Integrating mappings with sessions
• Working with Integration Service - Creating Worklets
• Sequential/Parallel flow of execution

Workflow Monitor

• Executing the workflows
• Executing sessions separately
• Hands on monitoring the applications (Required for Production support)
• Working on various issues