IBM InfoSphere DataStage Essentials v11.5 KM204G

Duration: 
4 days
Codes: 
KM204G,IBM
Versions: 
V11.5

Overview

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.

Audience

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

Skills Gained

  • 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

Prerequisites

  • Basic knowledge of Windows operating system
  • Familiarity with database access techniques

Course Outline

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

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Live Virtual
Live Virtual4 3000 £3000 2019-09-16
Live Virtual
Live Virtual4 3000 £3000 2019-09-23
Live Virtual
Live Virtual4 3000 £3000 2019-10-29
Live Virtual
Live Virtual4 3000 £3000 2019-11-25
Live Virtual
Live Virtual4 3000 £3000 2019-12-16