IBM InfoSphere DataStage Essentials 9.1

Course information
Price: € 2,595.00
Day(s): 4
Course Code: KM202G
GTC: 28

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.

Schedule
Course Details
26 Jun - 29 Jun, 2017
Virtual Training
01 Aug - 04 Aug, 2017
Virtual Training
02 Oct - 05 Oct, 2017
Virtual Training
11 Dec - 14 Dec, 2017
Virtual Training

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?

Course description

Download a PDF document of the complete course description: IBM InfoSphere DataStage Essentials 9.1

All course dates
Date & Location Language Ver
June
26 Jun - 29 Jun, 2017 Arrow ECS - Global Knowledge Leeds Public Classroom
26 Jun - 29 Jun, 2017 Arrow ECS - Birmingham Public Classroom
26 Jun - 29 Jun, 2017 Arrow ECS - Manchester Public Classroom
26 Jun - 29 Jun, 2017 Arrow ECS - Dublin Public Classroom
26 Jun - 29 Jun, 2017
Virtual Training
Virtual Learning
26 Jun - 29 Jun, 2017 Arrow ECS - London Dowgate Hill Public Classroom
August
01 Aug - 04 Aug, 2017 London - Old Broad Street Public Classroom
01 Aug - 04 Aug, 2017 Leeds Public Classroom
01 Aug - 04 Aug, 2017
Virtual Training
Virtual Learning
01 Aug - 04 Aug, 2017 Manchester Public Classroom
01 Aug - 04 Aug, 2017 Birmingham Public Classroom
28 Aug - 31 Aug, 2017 Zoetermeer (Centrum West 21) EN Public Classroom
28 Aug - 31 Aug, 2017
Virtual Training
EN Virtual Learning
September
18 Sep - 21 Sep, 2017 Zoetermeer (Centrum West 21) EN Public Classroom
18 Sep - 21 Sep, 2017
Virtual Training
EN Virtual Learning
October
02 Oct - 05 Oct, 2017 London - Old Broad Street Public Classroom
02 Oct - 05 Oct, 2017 Leeds Public Classroom
02 Oct - 05 Oct, 2017
Virtual Training
Virtual Learning
02 Oct - 05 Oct, 2017 Manchester Public Classroom
02 Oct - 05 Oct, 2017 Birmingham Public Classroom
November
27 Nov - 30 Nov, 2017 Zoetermeer (Centrum West 21) EN Public Classroom
27 Nov - 30 Nov, 2017
Virtual Training
EN Virtual Learning
December
11 Dec - 14 Dec, 2017 London - Old Broad Street Public Classroom
11 Dec - 14 Dec, 2017 Leeds Public Classroom
11 Dec - 14 Dec, 2017
Virtual Training
Virtual Learning
11 Dec - 14 Dec, 2017 Manchester Public Classroom
11 Dec - 14 Dec, 2017 Birmingham Public Classroom

This item has been added to your basket