Data Warehouse Fundamentals

Introduction to Data Warehousing

Purpose of Data Warehouse

Data Warehouse Architecture

Operational Data Store

OLTP Vs OLAP

Data Warehouse Life cycle

Data Modeling

Introduction to Data Modeling

Logical Modeling

Physical Modeling

Multi Dimensional Modeling

ETL Design Process - Types of ETL Tools

Introduction to Datastage

Datastage introduction

IBM information Server architecture

Datastage components

Datastage main functions

Client components

Datastage Administrator

Datastage project Administration

Editing projects and Adding Projects

Deleting projects Cleansing up project files

Global variable setting

Environment management

Auto purging

Runtime Column Propagation (RCP)

Add checkpoints for sequencer

System formats like data, timestamp

Project protect and Version details

Datastage Director

Introduction to Datastage Director

Validating Datastage Jobs

Executing Datastage jobs

Job execution status

Monitoring a job

Job log view

Job scheduling

Creating Batches

Scheduling batches

Datastage Designer

Introduction to Datastage Designer

Importance of Parallelism

Pipeline Parallelism

Partition Parallelism

Partitioning and collecting

Partition techniques

Datastage Repository Palette

Passive and Active stages

Job design overview

Designer work area

Annotations

Creating jobs

Importing flat file definitions

Managing the Metadata environment

Dataset management

Deletion of Dataset

Routines

Arguments

 

Different Types of Stages

Database Stages

File Stages

Processing Stages

Debug Stages

Real Time Stages

Containers

Job Sequencers

Arrange job activities in Sequencer

Triggers in Sequencer

Recoverability

Notification activity

Terminator activity

Wait for file activity

Start Look activity

Execute Command activity

Nested Condition activity

Exception handling activity

User Variable activity

End Loop activity

Adding Checkpoints

Other Features

Information Analyzer

WebSphere Quality Stage

IBM Information Server Administration Guide