Ray Wurlod

P.O. Box 1214

ABN 57 092 448 518

North Sydney  N.S.W.  2060

Education and Consulting Services

Australia

 

Email: rayw@mindless.com

 

 

DataStage™ Fundamentals – Server Edition

 

This page outlines the elements of the DataStage Fundamentals – Server Edition class, one of the services offered by this business.

It is an instructor-led class that can be delivered on-site (in a training room equipped with one PC per student and connectivity to a DataStage server).

 

Duration

 

Four days

 

 

Objectives

 

Having completed this class the student will be able:

•        to use DataStage tools to construct ETL tasks using DataStage server jobs

•        to compile and execute those tasks

•        to construct a hierarchy of control for those tasks

 

 

Contents

 

  1. Beginning DataStage: what DataStage is, how it works, what it is not
  2. Metadata: classes of metadata used by ETL developers
  3. Administrator client: setting/inspecting project-wide defaults
  4. Developer's Toolkit: introduction to the client tools that a developer uses
  5. Repository Manager: metadata creation, import, export and management
  6. Developing Jobs: standard, structured technique for constructing DataStage jobs
  7. Designer: editing jobs, job parameters, stages, links and their properties
  8. Transformer stage: the workhorse of server jobs; lookups, stage variables, constraints, derivations
  9. Hashed Files: populating and using hashed files
  10. Some other active stages: Aggregator, Sort, Pivot
  11. Director: execution and inspection/review tool
  12. Job Sequences: using a GUI to construct control hierarchies

 

 

Courseware

 

Each student receives the following two documents.

•        Student notes: Powerpoint presentation with detailed notes pages.

•        Lab Exercises:  Detailed instructions for "hands on" exercises to reinforce learning

 

 

DataStage is a trademarks of International Business Machines Corporation.

Formally the product name is IBM® Websphere® DataStage.

IBM and Websphere are registered trademarks of International Business Machines Corporation.

 

This page is copyright © 2006, Ray Wurlod. All rights reserved.