DW DataStage

IBM WebSphere DataStage and QualityStage - Version 8.0.1

Data Warehouse Fundamentals

* An Introduction to Data Warehousing
* Purpose of Data warehouse
* Data Warehouse Architecture
* Operational Data Store
* OLTP Vs Warehouse Applications
* Data Marts
* Data marts Vs Data Warehouses
* Data warehouse Life cycle
* Metadata management

Data Modelling

* Introduction to Data Modelling
* Entity Relationship model(E-R model)
* Data Modeling for Data Warehouse
* Dimensions and fact tables
* Star Schema and Snowflake Schemas
* Coverage Tables
* Fact less Tables
* what to look for in modelling tools
* Modelling tools

ETL Design process

* Introduction to Extraction, Transformation & Loading
* Types of ETL Tools
* What to look for in ETL Tools
* Key tools in the market
* ETL Trends & New Solution Options

Data stage installation

* Datastage Installation
* Prerequisites to install Datastage
* Installation process

Introduction to Datastage version 8.0.1

* Datastage Introduction
* IBM Information Server architecture
* DataStage within the 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)
* Enable Remote Execution of Parallel jobs
* Add checkpoints for sequencer
* NLS configuration
* Generated OSH (Orchestra Engine)
* System formats like date, timestamp
* Project protect
* 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
* Symmetric Multi Processing (SMP)
* Massively Parallel Processing (MPP)
* Partition techniques
* Datastage Repository
* Palette
* Passive and Active stages
* Job design overview
* Terminator activity
* Wait for file activity
* Start Look activity
* Execute Command activity
* Nested Condition activity
* Routine activity
* Exception handling activity
* User Variable activity
* End Loop activity
* Adding Checkpoints

Information Analyzer

* IBM WebSphere Information Analyzer overview
* Data profiling process
* Column analysis
* Primary key analysis
* Foreign key analysis
* Cross-domain analysis
* Baseline analysis
* Analysis result publication
* Deleting analysis results
* Reports for information analysis
* Column analysis summary statistics reports
* Baseline analysis reports
* Cross-domain analysis reports
* Primary key reports
* Foreign key analysis reports

WebSphere Quality Stage

* About Data Quality
* Datastage Quality stages
* Investigate stage
* Standardize stage Match Frequency stage
* Unduplicate Match stage
* Reference Match stage
* Survive stage

IBM Information Server Administration Guide

* IBM WebSphere DataStage administration
* Opening the IBM Information Server Web console
* Setting up a project in the console
* Customizing the project dashboard
* Setting up security
* Creating users in the console
* Assigning security roles to users and groups
* Managing licenses
* Managing active sessions
* Managing logs
* Managing schedules
* Backing up and restoring IBM Information Server