Data warehousing & Data Modeling

• Data warehousing -- introduction
• Database systems -- OLTP& DSS
• Warehouse Architecture
• Staging Areas & Data Marts
• Data Modeling
• Normalization and De- Normalization
• Concepts of ETL ( Extract ,Transaction and Load Process

• Informatica PowerMart/Power Center 5.1/6.0
  Informatica Server

• Setting Up and Configuring Informatica Server

Informatica Client

• Repository Manager/Server
• Designer
  
• Source Analyzer
• Warehouse designer
• Mapping Designer
• Mapplet Designer

Server manager / workflow manager

• Creating Sessions
• Executing Sessions

Workflow Manager

• Task Manager
• Creating Task
• Creating Workflow
• Executing Workflow

• Creating / Working with Repository
• Creating Groups, Users, Privileges
• Working with Designer Creating, Mapping Transformations and Mapplets
• Transformations

Cognos EP Series 7

• Data Warehouse Concepts
• Cognos Server
  • Power Play Enterprise Server
  • Upfront Server Administration
  • Access Manager administration
  • Deployment Manager
• Power Play Enterprise Server Tools
• Configuration Manager
• Access Manager Tools
  • Access Manager Configuration Wizard
  • Access manager Batch Maintenance
  • Access Manager Registration Wizard
• Scheduler
• Script Editor
• Impromptu Administrator
  • Creating Catalogs and imr reports
• Powerplay Transformer
• Creating Power Cubes
• Impromptu Web Reporting
• Publishing Cubes and reports to Upfront
• Power Play