TOPICS

What You’ll Learn
Use Connector stages to read from and write to database tables
Handle SQL errors in Connector stages
Use the Unstructured Data stage to extract data from Excel spreadsheets
Use the Big Data stage to read from and write to Hadoop HDFS files
Use the Data Masking stage to mask sensitive data processed within a DataStage job
Use the XML stage to parse, compose, and transform XML data
Use the Schema Library Manager to import and manage XML schemas
Use the Data Rules stage to validate fields of data within a DataStage job
Create custom data rules for validating data
Design a job that processes a star schema data warehouse with Type 1 and Type 2 slowly changing dimensions
Use the Surrogate Key Generator stage to generate surrogate keys
Who Needs to Attend
This advanced course is for Experienced DataStage developers seeking training in more advanced DataStage job techniques and who seek techniques for working with complex types of data resources.

Prerequisites
You should:

complete DataStage Essentials course or equivalent
and have at least one year of experience developing parallel jobs using DataStage
Follow-On Courses
There are no follow-ons for this course.

Course Outline
1. Accessing Databases
2. Processing Unstructured Data
3. Processing Big Data
4. Data Masking
5. Processing XML Data
6. Using Data Rules
7. Updating a Star Schema Database
All units are accompanied by hands-on lab exercises.