Trending Courses

Vendors

Skip Navigation Links

Overview

This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage v11.7. The emphasis is on developers. Only administrative functions that are relevant to DataStage developers are fully discussed. Students will learn to create parallel jobs that access sequential and relational data and combine and transform the data using functions and other job components.
img-course-overview.jpg

What You'll Learn

  • Describe the uses of DataStage, DataStage clients, and the DataStage workflow
  • Describe the two types of parallelism exhibited by DataStage parallel jobs
  • Describe what a deployment domain consists of, the different domain deployment options, and the installation process
  • Create new users and groups
  • Assign Suite roles and Component roles to users and groups
  • Give users DataStage credentials
  • Add a DataStage user on the Permissions tab and specify their role
  • Specify DataStage global and project defaults
  • List and describe important environment variables
  • Navigate the DataStage Designer
  • Import and export DataStage objects
  • Design a parallel job in DataStage Designer
  • Use the Row Generator, Peek, and Annotation stages in the job
  • Compile, run, and monitor a job
  • Create a parameter set and use it in a job
  • Read and write to sequential files using the Sequential File stage
  • Work with nulls in sequential files
  • Read from multiple sequential files using file patterns
  • Describe parallel processing architecture, pipeline parallelism, and partition parallelism
  • Describe partitioning and collecting algorithms
  • Describe the parallel job compilation process and how to use OSH (Orchestrate Shell Script)
  • Explain the Score
  • Combine data using the Lookup stage
  • Combine data using the Merge, Join, and Funnel stages
  • Sort data using in-stage sorts and the Sort stage
  • Combine data using the Aggregator stage and the Remove Duplicates stage
  • Use the Transformer stage in parallel jobs
  • Define constraints and derivations
  • Create a parameter set and use its parameters in constraints and derivations
  • Perform a simple Find, Advanced Find, and an impact analysis
  • Compare the differences between two table definitions and two jobs
  • Import table definitions for relational tables
  • Use ODBC and Db2 Connector stages in a job
  • Use SQL Builder to define SQL SELECT and INSERT statements
  • Use multiple input links into Connector stages to update multiple tables within a single transaction
  • Use the DataStage job sequencer to build a job that controls a sequence of jobs
  • Use Sequencer links and stages to control the sequence a set of jobs run in
  • Pass information in job parameters from the master controlling job to the controlled jobs
  • Handle errors and exceptions

Who Should Attend

This is a basic course for project administrators and ETL developers responsible for data extraction and transformation using DataStage.
img-who-should-learn.png

Prerequisites

You should have basic knowledge of the Windows operating system and some familiarity with database access techniques.

Learning Journey

Coming Soon...

  • Unit 01: Introduction to DataStage
  • Unit 02: Deployment
  • Unit 03: DataStage Administration
  • Unit 04: Working With Metadata
  • Unit 05: Creating Parallel Jobs
  • Unit 06: Accessing Sequential Data
  • Unit 07: Partitioning and Collecting Algorithms
  • Unit 08: Combining Data
  • Unit 09: Group Processing Stages
  • Unit 10: Transformer Stage
  • Unit 11: Repository Functions
  • Unit 12: Working with Relational Data
  • Unit 13: Control Jobs

img-exam-cert

Frequently Asked Questions (FAQs)

  • Why get IBM certified?

    IBM certifications validate your skills and expertise in a wide range of technologies, including hybrid cloud, data & AI, security, IT infrastructure, and business applications.

    These certifications are globally recognized and can help you advance your career, increase your earning potential, and demonstrate your commitment to professional development.

    IBM-certified professionals are in high demand, making them valuable assets to any organization seeking to leverage IBM's innovative solutions.

  • What to expect for the examination?

    IBM offers a variety of certification exams at different levels (Basic, Intermediate, and Advanced) covering various technologies and job roles.

    Exams typically consist of multiple-choice questions and may include scenario-based questions that assess your ability to apply your knowledge in real-world situations.

    Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • How long is IBM certification valid for?

    The validity period of IBM certifications varies. Some certifications, particularly those focused on specific product versions or technologies, may have expiration dates.

    However, many IBM certifications, especially those focused on broader skills or newer technologies, do not have an expiration date.

    Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • Why take this course with Trainocate?

    Here’s what sets us apart:

    - Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 24 countries (and counting!).

    - Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.

    - Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.

    - Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.

    - Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.

    - Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Course Curriculum

Training Schedule

Training Schedule

Exam & Certification

Exam & Certification

FAQs

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

More Courses By IBM

Browse All Courses
es90g-advanced-parallel-sysplex-operations-and-recovery-workshop-training
System Z

Advanced Parallel Sysplex Operations and Recovery Workshop

ES90G - Advanced Parallel Sysplex Operations and Recovery Workshop
ILT VILT
Course Duration 5 Days
b6258g-ibm-cognos-analytics-author-reports-fundamentals-v11
IBM Analytics

IBM Cognos Analytics: Author Reports Fundamentals v11.1.x

This course provides authors with an introduction to build reports using Cognos Analytics.
ILT VILT
Course Duration 3 Days
esb3g-ibm-z-os-management-facility-implementation-and-use-2-1-training
System Z

IBM z/OS Management Facility Implementation and Use 2.1

This course is designed to provide you with the skills required to install and customize, and use the functions and features provided by z/OSMF.
ILT VILT
Course Duration 3 Days
img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name*
Email*
Phone*
I'm inquiring for
Inquiry Details

By submitting this form, you consent to Trainocate processing your data to respond to your inquiry and provide you with relevant information about our training programs, including occasional emails with the latest news, exclusive events, and special offers.

You can unsubscribe from our marketing emails at any time. Our data handling practices are in accordance with our Privacy Policy.

Stay Connected. Be the first to Know.

Company

Vendors

Services

Customer Service

© Copyright Trainocate 2026. All rights reserved.