IBM InfoSphere DataStage Essentials 9.1

Course information
Price: Please Call
Day(s): 4
Course Code: KM202G
GTC: 28
Delivery Method: Virtual Learning

Overview

This course is designed to introduce ETL developers to DataStage 9.1.

This is the Classroom version of Instructor-led online course IBM InfoSphere DataStage Essentials 9.1 (ILO) (3M202GB).

Pre-Requisites

You should have basic knowledge of the Windows operating system and some familiarity with database access techniques.

Content

  • Unit 1 - Introduction to DataStage
  • Unit 2 - Deployment
  • Unit 3 - DataStage Administration
  • Unit 4 - Working with Metadata
  • Unit 5 - Creating Parallel Jobs
  • Unit 6 - Accessing Sequential Data
  • Unit 7 - Partitioning and Collecting
  • Unit 8 - Combining Data
  • Unit 9 - Group Processing Stages
  • Unit 10 - Transformer Stage
  • Unit 11 - Repository Functions
  • Unit 12 - Working with Relational Data
  • Unit 13 - Job Control
  • Unit 14 - Intersecting with Other Information Server Products

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
  • Read and write to database tables using DataStage ODBC and DB2 Connector stages
  • Work with the Repository functions such as search and impact analysis
  • Build job sequences that controls batches of jobs
  • Understand how FastTrack and Metadata Workbench can be profitably used with DataStage

Target Audience

This is a basic course for project administrators and ETL developers responsible for data extractions and transformations using DataStage.

Virtual Learning Schedule
Course Details
04 Apr - 07 Apr, 2017
Virtual Training
(EN)
28 Aug - 31 Aug, 2017
Virtual Training
(EN)
18 Sep - 21 Sep, 2017
Virtual Training
(EN)
27 Nov - 30 Nov, 2017
Virtual Training
(EN)

Key to symbols +

  • gauranteed Indicates a guaranteed course
  • special offer Indicates a special offer
  • late availability Indicates a late availability course
  • GTC What are GTCs?
Dates for all Delivery Formats
Date & Location Language Ver Delivery Method
April
04 Apr - 07 Apr, 2017
Virtual Training
EN Virtual Learning
August
28 Aug - 31 Aug, 2017
Virtual Training
EN Virtual Learning
September
18 Sep - 21 Sep, 2017
Virtual Training
EN Virtual Learning
November
27 Nov - 30 Nov, 2017
Virtual Training
EN Virtual Learning
All course dates
Date & Location Language Ver
April
04 Apr - 07 Apr, 2017
Virtual Training
EN Virtual Learning
25 Apr - 28 Apr, 2017
Virtual Training
Virtual Learning
June
26 Jun - 29 Jun, 2017
Virtual Training
Virtual Learning
August
28 Aug - 31 Aug, 2017
Virtual Training
EN Virtual Learning
28 Aug - 31 Aug, 2017
Virtual Training
EN Virtual Learning
28 Aug - 31 Aug, 2017
Virtual Training
EN Virtual Learning
September
18 Sep - 21 Sep, 2017
Virtual Training
EN Virtual Learning
18 Sep - 21 Sep, 2017
Virtual Training
EN Virtual Learning
18 Sep - 21 Sep, 2017
Virtual Training
EN Virtual Learning
November
27 Nov - 30 Nov, 2017
Virtual Training
EN Virtual Learning
27 Nov - 30 Nov, 2017
Virtual Training
EN Virtual Learning
27 Nov - 30 Nov, 2017
Virtual Training
EN Virtual Learning

This item has been added to your basket