IBM DataStage Online Course

Overview

Approx 36 Hours To Complete IBM DataStage Online Course in English Language

Data Warehousing Concepts
ETL Concepts
Introduction to DataStage
o Product Variants
o Architecture
o Server & Client components
Introduction to DataStage client
o Designer
o Director
o Manager
o Administrator
o Information Server
My First DataStage job
o Palette
o Repository
o Develop
o Compile
o Run
Introduction to DataStage Stages
o Sequential file
o Dataset
o Transformer
o Links
o Variables
o Reading, Writing to DB Tables
o Column Definitions
o Lookup
o Join
o Merge
o Modify
DataStage Functions
o Date Time
o Logical
o Mathematical
o Null Handling
o String
o Type Conversion
DataStage Sequences
o Job Activity
o Sequencer
o Exception Handler
o Notification Activity
o Wait for File
o Terminator
Debugging
o Debugger Interface
o Peek / Sample/ Head / Tail
Deployment
o Creating packages in Server Manager
o Import, Export of dsx file
Scheduling jobs
o Job Logs
o Job monitoring

Requirements

Laptop or desktop computer
Better Internet connectivity.
Understanding of English Language.

FAQ

Q. Who can join this course?
A: Those who want to learn IBM Datastage.
Q. How much time to learn IBM Datastage?
A: In 36 hours you can master your datastage.

Syllabus

DataStage course content
? Data Warehousing Concepts
? ETL Concepts
? Introduction to DataStage
o Product Variants
o Architecture
o Server & Client components
? Introduction to DataStage client
o Designer
o Director
o Manager
o Administrator
o Information Server
? My First DataStage job
o Palette
o Repository
o Develop
o Compile
o Run
? Introduction to DataStage Stages
o Sequential file
o Dataset
o Transformer
o Links
o Variables
o Reading, Writing to DB Tables
o Column Definitions
o Lookup
o Join
o Merge
o Modify
? DataStage Functions
o Date Time
o Logical
o Mathematical
o Null Handling
o String
o Type Conversion
? DataStage Sequences
o Job Activity
o Sequencer
o Exception Handler
o Notification Activity
o Wait for File
o Terminator
? Debugging
o Debugger Interface
o Peek / Sample/ Head / Tail
? Deployment
o Creating packages in Server Manager
o Import, Export of dsx file
? Scheduling jobs
o Job Logs
o Job monitoring