IBM InfoSphere DataStage Essentials (v11.5), Singapore

We can host this training at your preferred location. Contact us!

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.

Basic knowledge of Windows operating system
Familiarity with database access techniques

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

Introduction to DataStage
Deployment
DataStage Administration
Work with Metadata
Create Parallel Jobs
Access Sequential Data
Partitioning and Collecting Algorithms
Combine Data
Group Processing Stages
Transformer Stage
Repository Functions
Work with Relational Data
Control Jobs

Upcoming Trainings

Join our public courses in our Singapore facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom

14 October 2024