The DataStage® Fundamentals - Server Edition class is an instructor-led class designed to be delivered on-site, at your business location or a nearby training facility, 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
- 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
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 registered trademark of International Business Machines
Corporation.
IBM and the IBM logo are registered trademarks of
International Business Machines Corporation.
