Course Description
This unique 4-day IBM InfoSphere Advanced Datastage bootcamp training is designed to introduce advanced job development techniques in DataStage. This advanced course is for experienced developers seeking training in more advanced techniques and who seek an understanding of the parallel framework architecture. This course combines InfoSphere Advanced DataStage – Parallel Framework (3-days) and InfoSphere DataStage – Advanced Data Processing (2-days). Materials and environment for hands-on labs provided.
Course Outcomes
At the end of the course, learners will be able to:
- Describe the parallel processing architecture and development and runtime environments
- Describe the compile process and the runtime job execution process
- Describe how partitioning and collection works in the parallel framework
- Describe sorting and buffering in the parallel framework and optimization techniques
- Describe and work with parallel framework data types
- Create reusable job components
- Use loop processing in a Transformer stage
- Process groups in a Transformer stage
- Extend the functionality of DataStage by building custom stages and creating new Transformer functions
- Use Connector stages to read and write from relational tables and handle errors in Connector stages
- Process XML data in DataStage jobs using the XML stage
- Design a job that processes a star schema database with Type 1 and Type 2 slowly changing dimensions
- List job and stage best practices
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Audience |
|
Course Modules
- Module 1: Introduction to the Parallel Framework Architecture
- Module 2: Compilation and Execution
- Module 3: Partitioning and Collecting Data
- Module 4: Sorting Data
- Module 5: Buffering in Parallel Jobs
- Module 6: Parallel Framework Data Types
- Module 7: Reusable components
- Module 8: Advanced Transformer Logic
- Module 9: Extending the Functionality of Parallel Jobs
- Module 10: Accessing Databases (start if there is time)
- Module 11: Processing XML Data
- Module 12: Slowly Changing Dimensions Stages
- Module 13: Best Practices
Testimonials
“The SAP BOID10 Universe Designer class was a very enjoyable and informative course and we’re all looking forward to using the skills we learnt. We all agreed that the instructor was very good and was able to break down pretty complex issues to make them more understandable”
- Grahame Welch, Head of BI, UK Home Office
The trainers clear and obvious enthusiasm for number crunching, analytics, and teaching others is infectious. He doesn’t waste time, shows exactly what you need to know and is genuinely hilarious.
Every one of my employees had tons of positive stuff to say.
- Benjamin G, MXSG Analysis and Integration Chief, US Air Force
“Trainer was amazing. I was worried about staying engaged for 4 days, but the pace and explanation was exceptional! Would love to know what other training he provides.”
- Natalie Chronister, Project Administrator III, Carnegie Mellon University Software Engineering Institute
