This course enables the project administrators & developers to acquire the skills necessary to develop parallel jobs in DataStage. Students will learn to create parallel jobs that access sequential & relational data, and combine and transform the data.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Describe the uses of DataStage and the DataStage workflow Describe the Information Server architecture and how DataStage fits within it Describe the Information Server and DataStage deployment options Use the Information Server Web Console and the DataStage Administrator client to create DataStage users and to configure the DataStage environment Import and export DataStage objects to a file Import table definitions for sequential files and relational tables Design, compile, run, and monitor DataStage parallel jobs Design jobs that read and write to sequential files Describe the DataStage parallel processing architecture Design jobs that combine data using joins and lookups Design jobs that sort and aggregate data Implement complex business logic using the DataStage Transformer stage Debug DataStage jobs using the DataStage PX Debugger

1
  • Course Outline

  • Introduction to DataStage
    Deployment
    DataStage Administration
    Work with Metadata
    Create Parallel Jobs
    Access Sequential Data
    Partitioning and Collecting Algorithms
    Combine Data
    Group Processing Stages
    Transformer Stage
    Repository Functions
    Work with Relational Data
    Control Jobs

Audience

Project administrators and ETL developers responsible for data extraction and transformation using DataStage will benefit from this course.

Language

English

Prerequisites

Basic knowledge of Windows operating system & familiarity with database access techniques

$3,300

Length: 4.0 days (32 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
23
Oct
Monday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Schedule select
13
Nov
Monday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Schedule select
11
Dec
Monday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Loading...