Note: This is Base Content and may change
based on requirements.
Data warehousing contents
Introduction to Data
warehousing
Ø Who needs Data warehouse?
Ø Why Data warehouse is
required?
Ø Types of Systems
Ø (i)OLTP (ii) DSS
Ø Maintenance of Data
warehouse
Ø Data warehousing Life cycle
Ø Data warehousing Testing
Ute Cycle
Data warehousing
Architecture
Ø Source
Ø Integration Layer
Ø Staging Area
Ø Targets
Ø Analysis & Reporting
Ø HPQS
Data Modelling (Erwin)
Ø Introduction
Ø Different Phases of
Modeling
Multi Dimensional
Modelling
Ø What Is a Dimension?
Ø What are Facts?
Ø Multi Dimensional Model
Ø Hierarchies
Ø OLAP
Ø MOLAP
Ø ROLAP
Ø HOLAP • Cubes and its Functions
Ø Star Schema
Ø Fact Table
Ø Dimensional Tables
Ø Snow flake Schema
Ø Fact less Fact Table
Ø Confirmed Dimensions
Data Modelling Tools
Ø Forward Engineering
Ø Reverse Engineering
Ø Update Model, Alter
database
Ø Complete compare
Ø Mapping Source Qualifier as
Filter
Ø Source qualifier to join
Data
Ø Filter Transformation
Ø Expression Transformation
Ø Sequence Generator
Transformation
Ø Rank Transformation
Ø Router Transformation
Ø Aggregator Transformation
Ø Joiner Transformation
Ø Stored procedure
Transformation (Connected & Unconnected)
Ø Union Transformation
Ø XMl Transformation
Ø Mapping Wizards
Ø Implementing Type-I,
Type-II, Type-III
Ø Mappings
Informatica -workflow
Manager(Informatica 7.1)
Ø Workflow Introduction
Ø Tasks
Ø Workflow tools
Ø Connections
Ø Defining tasks
Ø (i) Command Task • (ii) Email Task
Ø (iii) Session Task
Ø (iv) Link Conditions
Ø (v) Event Wait & Event
Raise
Ø Setting Properties of
Session Task
Ø Creating Workflow
Ø Starting Workflow
Ø Monitoring Workflow
Informatica Advanced
Features
Ø Incremental Aggregation
Ø Mapplet Implementation
Ø Target Load Plan
Ø Constraint based Loading
Ø Mapping Parameters
Ø Mapping Variables
Ø Session parameters
Ø Link Conditions
Ø Meta Data Backup &
Restore
Ø Copying Repository
Ø Deleting Repository
Ø Sending Notification
Messages
Business Objects 6.5
with BO-XI
The course is yet to be scheduled