IBM InfoSphere DataStage Essentials v11.3

Course information
Price: € 250.00
Day(s): 4
Course Code: 1M203G
GTC: 28
Delivery Method: E-learning (Self-Paced)

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.

Add to Basket

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
June
19 Jun - 22 Jun, 2017
Virtual Training
Virtual Learning
July
10 Jul - 13 Jul, 2017
Virtual Training
Virtual Learning
August
14 Aug - 17 Aug, 2017
Virtual Training
Virtual Learning
September
25 Sep - 28 Sep, 2017
Virtual Training
Virtual Learning
November
13 Nov - 16 Nov, 2017
Virtual Training
Virtual Learning

This item has been added to your basket