Code: 
KM202G
Duration: 
4 Day(s)
Price: 
£2000-2200

Overview

This course is designed to introduce ETL developers to DataStage. Let us know which version you require. 

All IBM courses are delivered by IBM Global Training Providers.

Audience

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

Skills Gained

  • 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

Prerequisites

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

Course Specifics

Course Outline

  • 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

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Please click date to Enquire Now
Course Location Days Cost Date
Dublin4 2200 £2200 2017-11-13
Virtual4 2200 £2200 2017-11-13
Birmingham4 2200 £2200 2017-11-13
London4 2200 £2200 2017-11-13
Leeds4 2200 £2200 2017-11-13
Dublin4 2200 £2200 2017-11-06
Virtual4 2200 £2200 2017-11-06
Birmingham4 2200 £2200 2017-11-06
London4 2200 £2200 2017-11-06
Leeds4 2200 £2200 2017-11-06
Birmingham4 2000 £2000 2017-10-12
Dublin4 2200 £2200 2017-10-02
London4 2200 £2200 2017-10-02
Leeds4 2200 £2200 2017-10-02
Birmingham4 2200 £2200 2017-10-02
Virtual4 2200 £2200 2017-10-02
London4 2000 £2000 2017-09-28
Birmingham4 2200 £2200 2017-09-25
London4 2200 £2200 2017-09-25
Leeds4 2200 £2200 2017-09-25
Dublin4 2200 £2200 2017-09-25
Virtual4 2200 £2200 2017-09-25
London4 2200 £2200 2017-09-18
Leeds4 2200 £2200 2017-09-18
Dublin4 2200 £2200 2017-09-18
Virtual4 2200 £2200 2017-09-18
Birmingham4 2200 £2200 2017-09-18
Bristol4 2000 £2000 2017-09-04
Leeds4 2000 £2000 2017-08-31
London4 2200 £2200 2017-08-14
Virtual4 2200 £2200 2017-08-14
Birmingham4 2200 £2200 2017-08-14
Dublin4 2200 £2200 2017-08-14
Leeds4 2200 £2200 2017-08-14
Oxford4 2000 £2000 2017-08-14
London4 2200 £2200 2017-08-07
Leeds4 2200 £2200 2017-08-07
Dublin4 2200 £2200 2017-08-07
Virtual4 2200 £2200 2017-08-07
Birmingham4 2200 £2200 2017-08-07
Dublin4 2200 £2200 2017-08-01
Virtual4 2200 £2200 2017-08-01
Birmingham4 2200 £2200 2017-08-01
London4 2200 £2200 2017-08-01
Leeds4 2200 £2200 2017-08-01
Glasgow4 2000 £2000 2017-07-17
London4 2200 £2200 2017-07-10
Manchester4 2200 £2200 2017-07-10
Birmingham4 2200 £2200 2017-07-10
Dublin4 2200 £2200 2017-07-10
Leeds4 2200 £2200 2017-07-10