DATAWAREHOUSING CONTENTS

What is Data warehouse?
Characteristics of Data warehouse.
What is Data warehousing?
Principles of Data warehouse.
Benefits of DWH.
What is Online transactional systems (OLTP)?
Difference between OLTP and DWH.
Architecture of DWH.
HPQS.
Approaches of Data warehousing.
Normalization and Denormalization.
DWH Lifecycle:
Data Modeling
Dimension table
Fact Table
Aggregate table
Schemas
Star schema
Snowflake schema
Types Of Fact Tables:
Cumulative
Snapshot
Fact less Fact

Types Of Facts:
Additive
Semi Additive
Non Additive
Confirmed Dimension
Confirmed Fact
Degenerated Dimension
Casual Dimension
ODS
Cube
Hierarchies
Slowly changing Dimension Concepts
OLAP’s
Erwin

Getting Started
Erwin Workplace
Model Explorer
Dockable Toolbars
Stored Display Tabs
Basic Data Model Objects
Identifying
Non-identifying
Display Levels
Subject Area
Indexes

INFORMATICA
Introduction to Informatica
Products of Informatica
Difference between Power mart and Power center
Installation of Informatica
Configuring Informatica
Configuring Informatica Repository Server
Creating & Configuring Repository
Configuration Informatica Server
Configuration Temp Server(Workflow Manager)
Informatica Architecture
Informatica Client Tools
Designer (Components)
Source Analyzer
Workflow Manager (Components)
Workflow Monitor
Repository Manager
Repository Server Admin Console
Informatica Server Tools
Repository Server
Server
Transformations
Source Qualifier
Filter
Expression
Aggregator
Joiner
Router
Rank
Sorter
Sequence Generator
Union
Xml Source Qualifier
Lookup (Connected/Unconnected)
Stored Procedure (Connected/Unconnected)
Update Strategy
Transaction Control
Normalizer
Application Source Qualifier
Application multi-group Source Qualifier
Custom
Mapplet Input
Mapplet Output
Midstream XML Generator
Midstream XML Parser
Concepts
SQL Override
Working with files (Sources, Target)
File Repository Concept
Constrained Based Loading
Parameters
Mapping Parameters
Mapping Variables
Session Parameters
Incremental Aggregator
Application Source Qualifier
Debugging
Slowly Changing Dimension
BUSINESS OBJECTS

BO Reporting Tool

The Query Panel
Turning Tables to chart
Formatting Cells/Tables
The Structure View
Insertion of Rows or Columns
Breaks
Sections
Ranking
Filter
Alerters
Crosstabs
Grouping
Slice – and - Dice
Drill
Exporting Data
Data Providers
Master/Detail Reports
Introduction to BO Designer
Simple Universe and Object Creation
Creating Hierarchy
Resolving Loops and SQL Problems
Supervisor

BUSINESS OBJECTS

Introduction to Webintelligence
Getting started with Infoview
Viewing Documents in Infoview
Creating New Documents with queries
Restricting Data returned by a Query
Displaying information in different ways
Enhancing report presentation
Formatting reports
Creating Formulae and Variables

COGNOS

Cognos Impromptu
Power play Window
Transformer
Cognos Reportnet
Cognos Reportnet an Architecture
Cognos connection
Report studio
Query studio
Frame work manager