When does class start/end?
Class hours may vary, please reach out to contact@ascendientlearning.com if you have any questions.
IBM InfoSphere DataStage Essentials v11.7
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...
Read More
$3,800 USD
Duration
4 days
Course Code
KM304G
Available Formats
Classroom, Virtual
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.
Skills Gained
- 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 Can Benefit
This is a basic course for project administrators and ETL developers responsible for data extraction and transformation using DataStage.
Prerequisites
You should have basic knowledge of the Windows operating system and some familiarity with database access techniques.
Course Details
Course Outline
- 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
Schedule
7 options available
-
Jun 23, 2025 - Jun 26, 2025 (4 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Jul 28, 2025 - Jul 31, 2025 (4 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Aug 25, 2025 - Aug 28, 2025 (4 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Sep 29, 2025 - Oct 2, 2025 (4 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Oct 27, 2025 - Oct 30, 2025 (4 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Nov 17, 2025 - Nov 20, 2025 (4 days)
Live Virtual | 9:30AM – 5:30PM EST Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EST- Enroll
- Enroll Add to quote
-
Dec 15, 2025 - Dec 18, 2025 (4 days)
Live Virtual | 9:30AM – 5:30PM EST Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EST- Enroll
- Enroll Add to quote
FAQ
Does the course schedule include a Lunchbreak?
Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.
What languages are used to deliver training?
Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.
What does GTR stand for?
GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.
How do I find an Ascendient Learning training location?
We have training locations across the United States and Canada - View a complete list of classroom training locations.
Which delivery formats are available?
At Ascendient Learning, we offer training that is Instructor-Led, Online, Virtual, and Self-Paced.
Does Ascendient Learning deliver group training?
Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.
What does vendor-authorized training mean?
As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.
Is the training too basic, or will you go deep into technology?
It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.
How up-to-date are your courses and support materials?
We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.
Are your instructors seasoned trainers who have deep knowledge of the training topic?
Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.
Do you provide hands-on training and exercises in an actual lab environment?
Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.
Will you customize the training for our company’s specific needs and goals?
We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.
How do I get started with certification?
Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.
Will I get access to content after I complete a course?
You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.
How do I request a W9 for Ascendient Learning?
View our filing status and how to request a W9.
Reviews
Great company -- easy to sign up and very organized. Loved my teacher and class overall.
The training was great . But i expected some of the Networking concepts would be covered in this certification .
Instructor was great, course was mostly very good except for too much focus on pricing
I like their training. A lot of material covered. The labs are very good. l learned a lot.
The exit certified aws course provided a good introduction to the tools available on aws.
