Översikt
| Kurskod | 2I444SE | Leveranstyp | Self-paced Virtual Class |
|---|---|---|---|
| Kurslängd | 32.0 timmar | Kurstyp | |
| Listpris |
SEK 16 725,00 exkl moms
SEK 20 906,25 inkl moms |
In this course, you will learn about the features of IBM InfoSphere DataStage V8 and learn how to build and run DataStage Extract, Transform and Load (ETL) jobs. Also covered will be information on DataStage V8.1 in its IBM Information Server environment. You will 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. Additionally, you will 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.
This is a self-paced online course and includes hands-on remote labs. Once your registration is confirmed, you will receive detailed access instructions via email. You will have 28 days access to this course when it is started. The lab uses dual client/server images, that will run continuously for 20 days (480 hours) after the lab is first launched.
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.
The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.
Målgrupp
This is a basic course for project administrators and ETL developers responsible for data extraction and transformation using DataStage.
Förkunskaper
You should have:
- Knowledge of the Windows OS
- Familiarity with Open Database Connectivity (ODBC) and relational database access techniques
Mål
- 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
Nyckelområden
- 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
Hårdvarukrav
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
Virtual Lab Environment Test
Please use the following site to test your readiness to participate in a virtual session:
User: clp
Pass: ibmeduc
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.