02 9482 8200 info@datasync.com.au

KM400: IBM InfoSphere Advanced DataStage V8

Code: KM400
Duration: 4 days

Description

This course works with Information Server V8.5.

This course is designed to introduce advanced job development techniques in DataStage V8.5.

Outcomes

  • Describe the parallel processing architecture and development and runtime environments
  • Describe the compile process and the runtime job execution process
  • Describe how partitioning and collection works in the parallel framework
  • Describe sorting and buffering in the parallel framework and optimization techniques
  • Describe and work with parallel framework data types
  • Create reusable job components
  • Use loop processing in a Transformer stage
  • Process groups in a Transformer stage
  • Extend the functionality of DataStage by building custom stages and creating new Transformer functions
  • Use Connector stages to read and write from relational tables
  • Handle SQL errors in Connector stages
  • Process XML data in DataStage jobs using the XML stage
  • Design a job that processes a star schema database with Type 1 and Type 2 slowly changing dimensions
  • List job and stage best practices

Audience

This intermediate course is for experienced DataStage developers seeking training in more advanced DataStage techniques and who seek an understanding of the parallel framework architecture.

Prerequisites

You should have:

  • DataStage Essentials course or equivalent
  • and at least one year of experience developing parallel jobs using DataStage

Format

Classroom and hands on lab exercises.

This course is also offered as web-based training. Please contact us for more information.

Course Schedule »