IBM InfoSphere DataStage Essentials V8.7

Course details

This course works with Information Server V8.7 In this course, you will learn about the features of IBM InfoSphere DataStage V8 and learn how to build and run DataStage Extract, Transform and Load (ETL) jobs. Also covered will be information on DataStage V8.1 in its IBM Information Server environment. You will learn how to build DataStage parallel jobs that read and write data to and from a variety of data stores including sequential files, data sets, and relational tables. Additionally, you will learn how to build parallel jobs that process data in a variety of ways: business transformations, data filtering, data combining, data generation, sorting, and aggregating. This course replaces course IBM InfoSphere DataStage Essentials V8 (KM200GB). This is the Classroom version of Instructor-led Online course IBM InfoSphere DataStage Essentials V8.7 (ILO) (3M201GB), Self-Paced Virtual Course DataStage Essentials - SPVC (2I444GB), and Web-based course DataStage Essentials - Web Based (1I444GB).

Objectives:

• Combine data using lookup, join, and merge stages Conduct searches and impact analyses
• Create jobs that read from and write to sequential files Produce job reports
• Make jobs that read from and write to a relational database using Construct DataStage users the connector stages
• Administer the DataStage environment
• Build jobs that process data using transformations, combinations, filterings, sortings and aggregations