IBM InfoSphere DataStage Essentials v11.3

Course information
Price: € 2,595.00 Excl. VAT
Day(s): 4
Course Code: KM203G
GTC: 28
Delivery Method: Public Classroom

Overview

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

Pre-Requisites

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

Content

  • Unit 01: Introduction to DataStage
  • Unit 02: Deployment
  • Unit 03: DataStage Administration
  • Unit 04: Working With Metadata
  • Unit 05: Creating Parallel Jobs
  • Unit 06: Accessing Sequential Data
  • Unit 07: Partitioning and Collecting
  • Unit 08: Combining Data
  • Unit 09: Group Processing Stages
  • Unit 10: Transformer Stage
  • Unit 11: Repository Functions
  • Unit 12: Working with Relational Data
  • Unit 13: Job Control

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 control batches of jobs

Target Audience

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

Public Classroom Schedule

Dates available on request. Please contact us.

Course description

Download a PDF document of the complete course description: IBM InfoSphere DataStage Essentials v11.3

All course dates
Date & Location Language Ver
August
07 Aug - 10 Aug, 2017 Bahrain Public Classroom
13 Aug - 14 Aug, 2017 Burj Doha - West Bay Public Classroom
27 Aug - 30 Aug, 2017 Cairo-Sheraton Public Classroom
28 Aug - 31 Aug, 2017 Zoetermeer (Centrum West 21) EN Public Classroom
September
04 Sep - 07 Sep, 2017 Dubai-Knowledge Village Public Classroom
18 Sep - 21 Sep, 2017 Zoetermeer (Centrum West 21) EN Public Classroom
24 Sep - 27 Sep, 2017 Dammam Public Classroom
October
29 Oct - 01 Nov, 2017 Riyadh Public Classroom
November
14 Nov - 15 Nov, 2017 Burj Doha - West Bay Public Classroom
27 Nov - 30 Nov, 2017 Zoetermeer (Centrum West 21) EN Public Classroom
December
04 Dec - 07 Dec, 2017 Bahrain Public Classroom
11 Dec - 14 Dec, 2017 Dubai-Knowledge Village Public Classroom
11 Dec - 14 Dec, 2017 Johannesburg Public Classroom
24 Dec - 27 Dec, 2017 Cairo-Sheraton Public Classroom

This item has been added to your basket