Take advantage of spring savings with up to 50% off ILT training.

IBM InfoSphere DataStage Essentials (v11.5)

Learn the skills necessary to develop parallel jobs in DataStage.

This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage. 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.

GK# 3927 Vendor# KM204G

Vendor Credits:

Group Training

Group Training

Live expert-led training for your team or entire organization that can be customized to fit your exact needs.

No matching courses available.

Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.

Access Period:

Scheduling a custom training event for your team is fast and easy! Click here to get started.

Who Should Attend?

Project administrators and ETL developers responsible for data extraction and transformation using DataStage.

What You'll Learn

Describe the uses of DataStage and the DataStage workflow
Describe the Information Server architecture and how DataStage fits within it
Describe the Information Server and DataStage deployment options
Use the Information Server Web Console and the DataStage Administrator client to create DataStage users and to configure the DataStage environment
Import and export DataStage objects to a file
Import table definitions for sequential files and relational tables
Design, compile, run, and monitor DataStage parallel jobs
Design jobs that read and write to sequential files
Describe the DataStage parallel processing architecture
Design jobs that combine data using joins and lookups
Design jobs that sort and aggregate data
Implement complex business logic using the DataStage Transformer stage
Debug DataStage jobs using the DataStage PX Debugger

Course Outline

Module 1. Introduction to DataStage
Module 2. Deployment
Module 3. DataStage Administration
Module 4. Work with Metadata
Module 5. Create Parallel Jobs
Module 6. Access Sequential Data
Module 7. Partitioning and Collecting Algorithms
Module 8. Combine Data
Module 9. Group Processing Stages
Module 10. Transformer Stage
Module 11. Repository Functions
Module 12. Work with Relational Data
Module 13. Control Jobs

Prerequisites

Basic knowledge of Windows operating system
Familiarity with database access techniques

Download course details