Skip to main content

Course description: DataStage Essentials V8.1

Interested in bringing a class to you? Onsite training

Overview

List of course details in a data table
Course code DX444 Skill level Basic
Duration 4.0 days Delivery type Classroom
(Hands-on labs)
Course type Public or Private on-site    
Public price USD $2,995.00 plus tax  

Learn about the features of IBM WebSphere DataStage V8.1 and learn how to build and run DataStage Extract, Transform and Load (ETL) jobs.

Learn about DataStage V8.1 in its IBM Information Server environment. Learn how to build DataStage parallel jobs that read and write data to and from a variety of data stores including sequential files, data sets, and relational tables. Also, learn how to build parallel jobs that process data in a variety of ways: business transformations, data filtering, data combining, data generation, sorting, and aggregating.

View this course in other countries


Training Paths that reference this course are:

Back to top

Special note

IBM Education Advantage Program eligibility:

  • Yes - IBM Education Pack - online account

Back to top

Audience

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

Back to top

Prerequisites

You should have:

  • Knowledge of UNIX or Windows NT administration
  • Knowledge of TCP/IP and basic network principles
  • Data modeling experience
  • Familiarity with Open Database Connectivity (ODBC) and relational database access techniques

Back to top

Skills taught

  • Combine data using lookup, join, and merge stages
  • Create jobs that read from and write to sequential files
  • Make jobs that read from and write to a relational database using the connector stages
  • Build jobs that process data using transformations, combinations, filterings, sortings and aggregations
  • Conduct searches and impact analyses
  • Produce job reports
  • Construct DataStage users
  • Administer the DataStage environment

Back to top

Course outline

  • Deployment
  • Administration console
  • Designer
  • Director
  • Administrator
  • Accessing sequential data
  • Retrive relational data using connectors
  • Combining data
  • Transforming data
  • Repository
  • Job control
  • Metadata
  • Parallel framework
  • Complex Flat File stage
  • Slowly Changing Dimensions
  • MQ Connector
  • Performance Analyzer and Resource Estimator utilities

Back to top

Course materials

Course materials to be provided during delivery.

Back to top

My IBM

We're here to help

Easy ways to get the answers you need.

or call us at
Call 1-800-426-8322

Open M-F 9AM-7PM ET.

Student center

Find the right course

Offers and more