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