DSXchange Member Portal
Your Data Integration Community
DataStage Fundamentals Server Edition

DataStage Fundamentals
Server Edition

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
  • compile and execute those tasks
  • construct a hierarchy of control for those tasks

Contents:

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