Overview
| Course code | 1I004 | Skill level | Basic |
|---|---|---|---|
| Duration | 7.0 hours | Delivery type | Web Based Training |
| Course type | Public only | ||
| Public price | USD $340.00 plus tax |
Note: This is a self-paced online course in which the Guided Tour Product Simulation requires no installations: Everything is through your IE 5.0+ browser. Please DO NOT make travel arrangements for this course. After you receive confirmation that you are registered, just follow the instructions to access the course.
This browser-based product simulation lets you "learn-by-doing" in a case-study scenario in which you solve a 'real-life' business problem - no installations needed just a browser and a passion to learn.
By the end of this training you'll have a better understanding of this InfoSphere product's terminology, an overview of its architecture, and a better understanding of how it can be implemented.
You can learn more about the FlexLearning library:
http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=page&c=a0011797
USA IBM Training Registrar:
Phone: (978) 899-2188
Fax: (978) 899-2188
e-mail: iiseduc@us.ibm.com
Before putting you in the "driver's seat" in the Guided Tour Product Simulation, this course will first explain the concepts of DataStage, its architecture, and how to apply it to a 'real life' scenario in a business case-study in which you'll solve business problems. We will begin by looking at the big picture and discuss why businesses need ETL tools and where DataStage fits in the product set.
Once we've talked about the very basic architecture of DataStage, we'll investigate a business case-study, learn about a company called Amalgamated Conglomerate Corporation (ACC) - a fictitious holding company - and its business and technical needs. We'll then go about solving this company's problems with DataStage in a Guided Tour Product Simulation. In a practice environment, you'll become ACC's Senior DataStage Developer. In this capacity, you will assess an existing DataStage Job, build your own Job, modify a Job, and build a Sequencer Job.
Using the DataStage clients, you'll log onto the DataStage server and look at a Job that was built previously by the former DataStage Developer at ACC. You'll then build your own Job by importing meta data, building a Job design, compiling, running, troubleshooting, and then fixing this Job. You'll then modify a Job and finally build a special type of Job called a Sequence Job.
View this course in other countries
Training Paths that reference this course are:
Audience
This basic course is for:
- ETL Developers
- Data Integration Teams Migration Teams.
- Professionals seeking an overview of InfoSphere DataStage including:
- Database Administrators
- Business Intelligence Developers
- Data Modeling Professionals
- Both version 7.x and 8.x DataStage Developers
Prerequisites
You should have:
- Familiarity with data integration terminology and traditional ETL tools
- A working relationship with data integration team members at your company including the Database Administrator
- A high level familiarity with SQL
- Some previous experience using an ETL tool
Some programming experience would be helpful but is not necessary
Skills taught
- Create a DataStage Job, that can be used again and again in the future, to extract from and load to different sources and targets without changing its design
- Describe the ways that DataStage provides better performance, scalability, and flexibility when compared to other ETL tools
- Discuss the overall architecture of DataStage and how it can fit in the InfoSphere Information Server suite of products
- Solve a case-study business problem using DataStage
- Create re-usable local variables that support business decisions
Course outline
- The steps to build jobs
- Types of jobs
- Parallelism
- Partitioning
- Architecture
- Setting up the environment
- Passive Stages
- Active Stages
- Advanced concepts
- Solve a business problem using DataStage
- Create a job
- Modify a job
- Control the jobs