Course Details
Course Description:
The IBM InfoSphere DataStage Essentials (v11.5) course is a 4-day course that is designed to help project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage. The emphasis is on developers with only administrative functions which are relevant to DataStage developers are fully discussed. During the course, students will learn how to create parallel jobs that access sequential and relational data and combine and transform the data using functions and other job components.
Note: While class exercises are performed within an InfoSphere DataStage v11.5 environment, our expert instructors will provide guidance on all versions and their differences.
Topics covered in the course include:
- DataStage uses
- Information Server architecture and DataStage options
- Using the Information Server Web Console
- Importing and exporting DataStage objects
- Designing, compiling, running, and monitoring DataStage parallel jobs
- Designing jobs that read and write to sequential files
- DataStage parallel processing architecture
- Designing jobs that combine data using joins and lookups and that sort and aggregate data
- Implementing complex business logic
- Debugging DataStage jobs
Targeting Student:This course is designed for the following students:
Project administrators and ETL developers responsible for data extraction and transformation using DataStage.
Prerequisites: Students should possess the following experience before attending the course:
- Basic knowledge of Windows operating system
- Familiarity with database access techniques
Course Outline
Section 1. Introduction to DataStage
Section 2. Deployment
Section 3. DataStage Administration
Section 4. Work with Metadata
Section 5. Create Parallel Jobs
Section 6. Access Sequential Data
Section 7. Partitioning and Collecting Algorithms
Section 8. Combine Data
Section 9. Group Processing Stages
Section 10. Transformer Stage
Section 11. Repository Functions
Section 12. Work with Relational Data
Section 13. Control Jobs
- Basic knowledge of Windows operating system
- Familiarity with database access techniques
Virtual Live Instructor
Free Training Materials
Convenient Scheduling
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
We offer private IBM group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how IBM Private Group Training from Business Computer Skills can help your team.
