Course Content


  • Introduction about Data Stage
  • Difference between Server Jobs and Parallel Jobs
  • Difference between Pipeline Parallelisms
  • Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto)
  • Configuration File
  • Difference between SMP/MPD architecture
  • Data Stage Components (Server components/Client Components)
  • Package Installer

Data Stage Administrator

  • Creating project, Editing project and Deleting project
  • Permissions to user
  • .Apt Config file
  • Environment variable creation, permission

Data stage director

  • Introduction to Data stage Director
  • Job status View
  • View logs
  • Scheduling
  • Batches Creation


  • Introduction about Designer
  • Repository
  • Palatte
  • Types of Links
  • File Stages
  • Sequential File
  • Data set File
  • Lookup file set
  • Difference between Sequential file/Dataset/File set
  • Database stages
  • Dynamic RDBMS
  • Oracle Enterprise
  • ODBC Enterprise
  • Stored Procedure

Processing stages

  • Change Capture (Caption)
  • Compare stage
  • Difference Stage
  • Aggregate Stage
  • Transformer Stage
  • Surrogate Generator Stage
  • Join Generator Stage
  • Merge Generator Stage
  • Lookup Generator Stage
  • Difference between join/Lookup/Merge
  • Difference between join/Lookup
  • Remove Duplicates
  • Switch
  • Pivot
  • Modify
  • Funnel

Debugging stage

  • Head
  • Tail
  • Pea
  • Row Generator
  • Column Generator
  • Sample
  • Job Parameters


  • Introduction About Data stage Manager
  • Importing the Job
  • Exporting the Job
  • Importing Table Definition
  • Importing Flat File Definition
  • Routines


  • Difference between Local Container and Shared Container
  • Local Container
  • Shared Container

Trainer’s Profile: Trainer is Working Consultant from IBM with 8+ years of Consulting and Training Experience. Datastage Training Academy strictly follows the policy of employing working Datsatge Professional as a Trainer and by this only we can maintain the quality of the training.

Course Duration: 4 Weeks (Around 60 Hours) of Class Room Training.
Course Fee: 25,000 INR.
Trainer’s Contact Details: Ph. +91-9325793756
Mode of Training: This would be a class Room Based Training.

Hadoop Server Access: We required student to come up with system or Laptop and we will install Datastage Software on the same.

Books and Study Material: Datastage Training Academy will provide all Study Material and Books for this course in Soft Copy format.

Self-Practice Required: If you are looking to get into Datastage developer roles so please dedicated 200-300 Hrs. of Self-study and Practice in order to get command on the system and then only you can easily clear’s Datastage Developer’s Interviews.

Background Need to get into this course: This course suits to the people who are coming from Business Degree Background (BE, MCA, MSc. etc.).