Overview
| Course code | 1I444 | Skill level | Basic |
|---|---|---|---|
| Duration | 32.0 hours | Delivery type | Web Based Training |
| Course type | Public only | ||
| Public price | USD $1,360.00 plus tax |
This is the Web-Based version of Classroom course IBM InfoSphere DataStage Essentials V8 (KM200), Instructor-Led Online course IBM InfoSphere DataStage Essentials V8 - (ILO) (3M200) and Self-Paced Virtual course DataStage Essentials - (SPVC) (2I444).
Note: This is a self-paced online course. This course usually requires 32 hours to complete. Once you receive your access information, you will have 60 days access to this course.
Learn about the features of IBM WebSphere DataStage V8.1 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.
Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course materials.
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
- 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
Course outline
- Deployment
- Administration console
- Designer
- Director
- Administrator
- Accessing sequential data
- Retrive relational data using connectors
- Combining data
- Transforming data
- Repository
- Job control
- Metadata
- Parallel framework
- Complex Flat File stage
- Slowly Changing Dimensions
- MQ Connector
- Performance Analyzer and Resource Estimator utilities
Machine requirements
HW/SW CONFIGURATION
The minimum hardware and software required to launch the course are:
- Reliable HIGH-SPEED INTERNET connection (min 200 kbps up and down)
- Windows 2000 or XP or Vista
- Computer with soundcard
- Headset or computer speakers
- Internet Explorer 5.01 or later, or Firefox 1.0 or later
Network Speed Test
Please test your network internet access speed using the following URL, or a similar site:
http://speedtest.atlanta.ibm.com
For example, a speed test against the Atlanta, USA server with a slow connection of 140 Kbps download and 28 Kbps upload took 14 minutes to load a 30min recording before the video began. Extrapolate from this result to estimate how fast your network internet access would be approximately. High-speed broadband internet access is the recommended configuration for this course.
Keyboard Configuration
If you use a different character keyboard, you may experience errors when entering passwords. If possible, change your language/country settings for your keyboard to USA, which allows you to enter characters as in a QWERTY keyboard.