This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | DX434 | Skill level | Basic |
|---|---|---|---|
| Duration | 4.0 days | Delivery type | Instructor Led - Online Training
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $2,995.00 plus tax | ||
This course was formerly course numbers DS324EE / DS434.
Learn how to create complex applications that require the use of standard stages. Gain hands-on experience by building and creating jobs that might be used in a typical solution. Discuss topics that also include DataStage standards, Enterprise Edition (EE) internal engine architecture, in-depth configuration options, and job control solutions.
Course Materials
The course materials address DataStage Essentials for Enterprise Edition - Version 7.x
Hands-On Labs
Several labs are included throughout the delivery to address and reinforce the skills discussed.
Audience
This is a basic course for project administrators and ETL developers responsible for data extraction and transformation using DataStage
Prerequisites
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
Skills taught
- Use standard stages to create a typical application
- Configure projects to expose underlying generated code
- Review the underlying generated code
- Schedule, compile, and run DataStage jobs in a networked hierarchy
Course outline
- Introduction
- Setting up your DataStage environment
- Creating parallel jobs
- Accessing sequential data
- Platform architecture
- Combining data
- Sorting and aggregating data
- Transforming data
- Standards and techniques
- Accessing relational data
- Compilation and execution
- Testing and debugging
- Metadata in EE
- Job control
