What You’ll Learn
Uses of DataStage and the DataStage workflow
Information Server architecture and how DataStage fits within it
Information Server and DataStage deployment options
Use the Information Server Web Console and the DataStage Administrator client to create DataStage users and to configure the DataStage environment
Import and export DataStage objects to a file
Import table definitions for sequential files and relational tables
Design, compile, run, and monitor DataStage parallel jobs
Design jobs that read and write to sequential files
DataStage parallel processing architecture
Design jobs that combine data using joins and lookups
Design jobs that sort and aggregate data
Implement complex business logic using the DataStage Transformer stage
Debug DataStage jobs using the DataStage PX Debugger
Read and write to database tables using DataStage ODBC and DB2 Connector stages
Work with the repository functions such as search and impact analysis
Build job sequences that control batches of jobs
How FastTrack and Metadata Workbench can be profitably used with DataStage
How to work with unstructured data such as Microsoft Excel worksheet data
Who Needs to Attend
Project administrators and ETL developers responsible for data extraction and transformation using DataStage

Basic knowledge of the Windows operating system
Familiarity with database access techniques
Follow-On Courses
There are no follow-ons for this course.

Course Outline
1. Introduction to DataStage
2. DataStage Deployment Scenarios
3. Creating DataStage Administration
4. Import a Table Definition
5. Creating Parallel Jobs
6. Accessing Sequential Data
7. Reading and Writing NULL Values to a Sequential File
8. Working with Data Sets
9. Partitioning and Collecting
10. Combining Data
11. Group Processing Stages
12. Transformer Stage
13. Repository Functions
14. Working with Relational Data
15. Job Control
16. Processing Unstructured Data
Hands on labs are included in each chapter.

  • 10 Days
  • 0 Units
  • 0 Hrs

Select Your Currency

WOOCS 1.1.8
Drop Us A Query
[contact-form-7 id="5639" title="Drop Us A Query"]
Create an Account