Introduction
Learn about DataStage v8 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. You will also 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.
Audience
This is a basic course for project administrators who extract and transform data using DataStage.
Pre-requisites
You should have:
Knowledge of UNIX or Windows NT administration
Knowledge of TCP/IP and basic network principles
Data modeling experience
Familiarity with Open Database Connectivity (ODBC) and relational database access techniques
At Course Completion
After completing this course, you should be able to:
Combine data using Lookup, Join, and Merge stages
Build jobs that read from and write to sequential files
Build jobs that read from and write to a relational database using the Connector Stages
Build jobs that process data using transformations, combinations, fileterings, sortings, and aggregations
Conduct searches and impact analyses
Create job reports
Create DataStage users
Adminster the DataStage environment
:: Course DX444MY ::
Course Outline
Deployment
Administration console
Designer
Director
Administrator
Accessing sequential data
Accessing relational data using Connectors
Combining data
Transforming data
Repository
Job control
Metadata
Parallel framework
Complex Flat File stage
Slowly Changing Dimensions
MQ Connector
Performance Analyzer and Resource Estimator utilities
This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.