02 9482 8200 info@datasync.com.au

KM202: IBM InfoSphere DataStage Essentials 9.1

Code: KM202
Duration: 4 days

Description

This course is designed to introduce ETL developers to DataStage 9.1.

Outcomes

  • 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
  • Read and write to database tables using DataStage ODBC and DB2 Connector stages
  • Work with the Repository functions such as search and impact analysis
  • Build job sequences that controls batches of jobs
  • Understand how FastTrack and Metadata Workbench can be profitably used with DataStage

Audience

This is a basic course for project administrators and ETL developers responsible for data extraction and transformation using DataStage.

Prerequisites

You should have a basic knowledge of the Windows operating system and some familiarity with database access techniques.

Format

Classroom and hands on lab exercises.

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

Course Schedule »