DataStage

Contents

This course has been designed to guide the student about the DataStage Capabilities to develop a sound business decision based on enterprise data which is scattered throughout the  enterprise, across multiple applications, departments and divisions.DataStage, a core component of the IBM WebSphere Data Integration Suite, enables you to tightly integrate enterprise information, despite having many sources or targets and short time frames. Whether you're building an enterprise data warehouse to support the information needs of the entire company, building a "real time" data warehouse, or integrating dozens of source systems to support enterprise applications like customer relationship management (CRM), supply chain management (SCM), and enterprise resource planning (ERP), WebSphere DataStage helps ensure that you will have information you can trust.

WebSphere DataStage delivers three key capabilities necessary for success in enterprise data integration: the most comprehensive connectivity to easily and quickly access any source or target system; advanced development and maintenance tools, which speed implementation and simplify administration; and a scalable platform that can easily handle today's massive volumes of corporate data.

Objectives                                                                             

• How to develop a DataStage Job..
• How to use the various types of stages that may be found in DataStage.
• How to design for efficient DataStage Jobs for faster retrieval of Data.
• Functionality of DataStage Manager, DataStage  Director and DataStage Administrator.

Topics

DataStage Designer

• DataStage Designer Overview
• Job Design Flow
• Create a Job
• Table Definition
• Adding Stages
• Palette for Stages
• Stage Types
• Adding Links
• Grouping Stages & Links
• Compiling & Running Jobs
• Debugging
• Naming Constraints
• Job Properties
• Job Sequences
• Programming in DataStage

DataStage Manager

• DataStage Manager Overview
• Managing the Repository
• Managing Tables
• Built-in- Data Elements
• Built-in-Functions
• Custom Routines
• Managing Job Properties
• Managing Shared Containers
• Importing and Exporting Jobs
• Package Creation

DataStage Director