Datastage Training

Datastage Training

DataStage is a central filestore with three added benefits: Security controls that allow researchers to have a "private" area only accessible to themselves and the group leader, and "shared" and "collaborative" areas to put files of use to the whole research group.

Course Information

Datastage Course Duration: 30 Hours

Datastage Training Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

Datastage Training Method: Online/Classroom Training

Datastage Study Material: Soft Copy

Course Content

Unit -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.

Unit -2: Data Modeling

Introduction to Data Modeling

Entity Relationship model (E-R model)

Data Modeling for Data Warehouse, Normalization process

Dimensions and fact tables  

Star Schema and Snowflake Schemas.

Unit -3: ETL Design Process

Introduction to Extraction, Transformation & Loading

Types of ETL Tools

Key tools in the market.

Unit – 4: Introduction to Data stage Version 7.5x2 & 8.1& 8.5

Data stage introduction

IBM information Server architecture

Data stage components

Data Stage main functions

Client components- Adding different Servers to our workspace.

Unit – 5:  Data stage Administrator

Data stage project Administration

Editing projects and Adding Projects

Deleting projects Cleansing up project files

Environmental Variables

Environment management  

Auto purging

Runtime Column Propagation(RCP)

Add checkpoints for sequencer

NLS configuration

Generated OSH (Orchestra Engine)

System formats like data, timestamp

Projects protect – Version details.

Unit – 6:  Data stage Director

Introduction to Data stage Director

Validating Data stage Jobs

Executing Data stage jobs  

Job execution status

Monitoring a job

Job log view  

Job scheduling

Creating Batches

Scheduling batches.

Unit – 7:  Data stage Designer

Introduction to Data stage Designer

Importance of Parallelism

Pipeline Parallelism

Partition Parallelism

Partitioning and collecting(In depth coverage of partitioning and collective techniques)

Symmetric Multi Processing (SMP)

Massively Parallel Processing (MPP)

Introduction to Configuration file

Editing a Configuration file

Partition techniques  

Data stage Repository Palette  

Passive and Active stages  

Job design overview

Designer work area


Creating jobs

Importing flat file definitions

Managing the Metadata environment

Dataset management

Deletion of Dataset  


Unit – 8:  Working with Parallel Job Stages

Database Stages



 Dynamic RDBMS

File Stages

Sequential file


File set  

Lookup file se

Processing Stages





Remove duplicate



Pivot stage




Difference between look up, join and merge

Change capture

External Filter

Surrogate key generator


Real time scenarios using different Processing Stages - Implementing different logics using Transformer

Debug Stages




Column generator

Row generator

Write Range Map Stage

Real Time Stages

XML input 

XML output

Local and Shared containers

Routines creation

Extensive usage of Job parameters, Parameter Sets, Environmental variables in jobs

Introduction to predefined Environmental variables creating user defined Environmental variables and implementing the same in parallel jobs

Unit – 9:  Advanced Stages in Parallel Jobs (Version 8.1)

Explanation of Type1 and Type 2 processes

Implementation of Type1 and Type2 logics using Change Capture stage and SCD Stage

Range Look process  

Surrogate key generator stage

FTP stage  

Job performance analysis

Resource estimation

Performance tuning

Unit – 10: Job Sequencers

Arrange job activities in Sequencer

Triggers in Sequencer



Notification activity  

Terminator activity  

Wait for file activity

Start Loop activity

Execute Command activity

Nested Condition activity

Exception handling activity  

User Variable activity

End Loop activity

Adding Checkpoints

Jobs used in different real time scenarios.

Explanation of Sequence Job stages through different Jobs

Unit – 11: IBM Information Server Administration Guide

IBM Web Sphere Data stage administration

Opening the IBM Information Server Web console –

Setting up a project ion 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.

Key Features

Instructor Led Datastage Online Training

Flexible Time At Your Convenience

Over 1,00,000+ Professionals Trained Across 100 Countries

24x7 Live Support via Chat, Mail and Phone

Corporate Training and On-Job Support

Request for demo