IBM InfoSphere DataStage v11.5 - Advanced Data ProcessingNewly Released

IBM InfoSphere DataStage v11.5 - Advanced Data Processing Course Description

Duration: 2.00 days (16 hours)

Price: $1,400.00

This course is designed to introduce you to advanced parallel job data processing techniques in DataStage v11.5. In this course you will develop data techniques for processing different types of complex data resources including relational data, unstructured data (Excel spreadsheets), and XML data. In addition, you will learn advanced techniques for processing data, including techniques for masking data and techniques for validating data using data rules. Finally, you will learn techniques for updating data in a star schema data warehouse using the DataStage SCD (Slowly Changing Dimensions) stage. Even if you are not working with all of these specific types of data, you will benefit from this course by learning advanced DataStage job design techniques, techniques that go beyond those utilized in the DataStage Essentials course.

Next Class Dates

Sep 28, 2017 – Sep 29, 2017
10:00 AM – 7:00 PM ET

View More Schedules »

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

Intended Audience for this IBM InfoSphere DataStage v11.5 - Advanced Data Processing Course

  • » Experienced DataStage developers seeking training in more advanced DataStage job techniques and who seek techniques for working with complex types of data resources.

Back to Top

IBM InfoSphere DataStage v11.5 - Advanced Data Processing Course Objectives

  • » Use Connector stages to read from and write to database tables
  • » Handle SQL errors in Connector stages
  • » Use Connector stages with multiple input links
  • » Use the File Connector stage to access Hadoop HDFS data
  • » Optimize jobs that write to database tables
  • » Use the Unstructured Data stage to extract data from Excel spreadsheets
  • » Use the Data Masking stage to mask sensitive data processed within a DataStage job
  • » Use the Hierarchical 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

Back to Top

IBM InfoSphere DataStage v11.5 - Advanced Data Processing Course Outline

      1. Accessing databases
        1. Connector stage overview
          1. Use Connector stages to read from and write to relational tables
          2. Working with the Connector stage properties
        2. Connector stage functionality
          1. Before / After SQL
          2. Sparse lookups
          3. Optimize insert/update performance
        3. Error handling in Connector stages
          1. Reject links
          2. Reject conditions
        4. Multiple input links
          1. Designing jobs using Connector stages with multiple input links
          2. Ordering records across multiple input links
        5. File Connector stage
          1. Read and write data to Hadoop file systems
      2. Processing unstructured data
        1. Using the Unstructured Data stage in DataStage jobs
          1. Extract data from an Excel spreadsheet
          2. Specify a data range for data extraction in an Unstructured Data stage
          3. Specify document properties for data extraction.
      3. Data masking
        1. Using the Data Masking stage in DataStage jobs
          1. Data masking techniques
          2. Data masking policies
          3. Applying policies for masquerading context-aware data types
          4. Applying policies for masquerading generic data types
          5. Repeatable replacement
          6. Using reference tables
          7. Creating custom reference tables
      4. Using data rules
        1. Introduction to data rules
          1. Using the Data Rules Editor
          2. Selecting data rules
          3. Binding data rule variables
          4. Output link constraints
          5. Adding statistics and attributes to the output information
        2. Use the Data Rules stage to valid foreign key references in source data
        3. Create custom data rules
      5. Processing XML data
        1. Introduction to the Hierarchical stage
          1. Hierarchical stage Assembly editor
          2. Use the Schema Library Manager to import and manage XML schemas
        2. Composing XML data
          1. Using the HJoin step to create parent-child relationships between input lists
          2. Using the Composer step
        3. Writing Hierarchical data to a relational table
        4. Using the Regroup step
        5. Consuming XML data
          1. Using the XML Parser step
          2. Propagating columns
        6. Transforming XML data
          1. Using the Aggregate step
          2. Using the Sort step
          3. Using the Switch step
          4. Using the H-Pivot step
      6. Updating a star schema database
        1. Surrogate keys
          1. Design a job that creates and updates a surrogate key source key file from a dimension table
        2. Slowly Changing Dimensions (SCD) stage
          1. Star schema databases
          2. SCD stage Fast Path pages
          3. Specifying purpose codes
          4. Dimension update specification
          5. Design a job that processes a star schema database with Type 1 and Type 2 slowly changing dimensions

Back to Top

Do you have the right background for IBM InfoSphere DataStage v11.5 - Advanced Data Processing?

Skills Assessment

We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.

Our required skill-assessments ensure that:

  1. All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
  2. NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
  3. We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

Take your FREE Skill Assessment test »

Back to Top

Award winning, world-class Instructors

Our instructors are passionate at teaching and are experts in their respective fields. Our average NetCom instructor has many, many years of real-world experience and impart their priceless, valuable knowledge to our students every single day. See our world-class instructors.   See more instructors...

Back to Top

Client Testimonials & Reviews about their Learning Experience

We are passionate in delivering the best learning experience for our students and they are happy to share their learning experience with us.
Read what students had to say about their experience at NetCom.   Read student testimonials...

Back to Top

Ways to contact us

Back to Top