Data Wareshousing

DATA WAREHOUSING COURSE CONTENTS/SYLLABUS

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.

Approaches of Data warehousing.

DWH Lifecycle

Data Modeling

Dimension table

Fact Table

Schemas

Star schema

Snowflake schema

Fact less Fact

Confirmed Dimension

ODS

Cube

Hierarchies

Slowly changing Dimension Concepts

OLAP’s

INFORMATICA

Introduction to Informatica

Products of Informatica

(Installation of Informatica)

Configuring Informatica

Configuring Informatica Repository Server

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

Mapplet Input

Mapplet Output

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

Target Load plan

informatica partitioning