IBM What's New in IBM InfoSphere DataStage
This course works with Information Server V8.5.
This course is for experienced DataStage 7.5 developers who are upgrading to DataStage 8.5. DataStage 7.5 was a stand-alone product. DataStage 8.5 is part of suite of components and tools that share a common Repository and backbone of services. After introducing this new DataStage environment and how to develop within it, the new features and capabilities of DataStage are covered. This includes Transformer and Lookup stage enhancements as well as an introduction to the new Connector stages for reading and writing relational data. The course then examines some major new stages. These include the Complex Flat File stage for processing mainframe files with multiple record formats, the new XML stage for processing XML data, and the Slowly Changing Dimensions stage for updating data marts with slowly changing dimensions.
Work within the new DataStage Information Server environment
Create DataStage user IDs in the Information Server Web Console
Create range lookups
Use loops in the Transformer to parse out fields of a single row into multiple separate rows
Process groups in the Transformer
Use Connector stages to read and write to relational tables
Update tables with slowly-changing dimensions using the new Slowly-Changing Dimensions stage
Use new DataStage utilities to analyzer job performance and resource usage
Work with the new Repository functions
Understand how FastTrack and Metadata Workbench can be profitably used with DataStage
DataStage 7.5 developers who will be upgrading to DataStage 8.5.
Those taking this course should have at least one 1 year experience developing parallel jobs in DataStage 7.5.
Introduction: Overview of what's new and what's the same.
What gets deployed
Possible deployment configurations
New Suite Installer
Information Server web console
What's New in DataStage Administrator?
What's new in Designer?
Transformer Stage Enhancements
Lookup stage enhancements
Flexible folder organization
DataStage component export enhancements
Job and Table Definition differences
Working with Relational Data
Data Connection objects
Multiple input links
Complex Flat File Stage
Intersecting with other IS tools: Just slides
Shared metadata Repository
FastTrack: Point them to FastTrack course
Metadata Workbench: Point them to MWB course