IBM InfoSphere DataStage Essentials 9.1

Course details

This course is designed to introduce ETL developers to DataStage 9.1. This is the Classroom version of Instructor-led online course IBM InfoSphere DataStage Essentials 9.1 (ILO) (3M202GB)

Objectives:

• Describe the uses of DataStage and the DataStage workflow
• Design jobs that combine data using joins and lookups
• Describe the Information Server architecture and how DataStage fits within it
• Design jobs that sort and aggregate data
• Describe the Information Server and DataStage deployment
• options Implement complex business logic using the DataStage Transformer stage
• Use the Information Server Web Console and the DataStage Administrator client to create DataStage users and to configure Debug DataStage jobs using the DataStage PX Debugger the DataStage Environment
• Read and write to database tables using DataStage ODBC and DB2
• Import and export DataStage objects to a file Connector stages
• Import table definitions for sequential files and relational tables Work with the Repository functions such as search and impact analysis
• Design, compile, run, and monitor DataStage parallel jobs
• Build job sequences that controls batches of jobs
• Design jobs that read and write to sequential files
• Understand how FastTrack and Metadata Workbench can be profitably used with DataStage
• Describe the DataStage parallel processing architecture