Course description
Learn about the features of IBM InfoSphere DataStage V8 and learn how to build and run DataStage Extract, Transform and
Load (ETL) jobs.
Learn about DataStage V8.1 in its IBM Information Server environment. 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. 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.
General information
Delivery method: Classroom
Audience: This is a basic course for project administrators and ETL developers responsible for data extraction and transformation using DataStage
Learning objectives: After completing this course, students should be able to:
Combine data using lookup, join, and merge stages
Create jobs that read from and write to sequential files
Make jobs that read from and write to a relational database using the connector stages
Build jobs that process data using transformations, combinations, filterings, sortings and aggregations
Conduct searches and impact analyses
Produce job reports
Construct DataStage users
Administer the DataStage environment
Prerequisites: Before taking this course, students should have:
Knowledge of the Windows OS
Familiarity with Open Database Connectivity (ODBC) and relational database access techniques
Duration: 4 days
Skill level: Beginners
Contents
Deployment
Administration console
Designer
Director
Administrator
Accessing sequential data
Retrive relational data using connectors
Combining data
Transforming data
IBM Information Management Education
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.