Duration
4 days
Course Description
Learn how to build Server jobs in the IBM DataStage V8 Information Server environment. You will learn how to build DataStage Server jobs that read and write data from a variety of data stores, including sequential files, hashed files, and relational tables. You will also learn how to build Server jobs that process data in a variety of ways: business transformations, data filtering, and aggregating.
Abstract
IBM Education Advatage Program Eligibility:
- Yes - IBM Education Pack - Online Account
Audience
This is a basic course for developers who extract and transform data using DataStage Server jobs.
Pre-requisites
You will be expected to know how to the following concepts:
- Windows/UNIX comand line familiarity
- Windows graphical user interface navigation skills
- Understanding of some programming lanugage concepts
- Understanding of Relational DBMS concepts
Course Objective
- Configure the DataStage environment
- Build jobs that read from and write to sequential files
- Build jobs that read from and write to a relational database using ODBC
- Build jobs that process data using transformations, aggregations, sorting, and pivoting
- Troubleshoot DataStage jobs using the online Debugger
- Create job sequencer to control jobs
- Create DataStage jobs using IPC stage, link partitioners and collectors, to enhance job performance
Introduction
- Administration
- Designer-Repository Management
- Designer-Job Development
- Director
- Accessing Relational Data
- Creating Reusable Components
- Hashed File
- Transforming Data
- Advanced Transforms
- Aggregating Data
- Using Plug-Ins
- Troubleshooting
- Job Sequencers
- Performance Enhancements
Programme scope, delivery arrangements and suitability are confirmed during enquiry.