Session : 1 – Datastage Introduction

  • DataStage Architecture
  • DataStage Clients
  • Designer
  • Director
  • Administrator
  • DataStage Workflow

Session : 2 – Types of DataStage Job

  • Parallel Jobs
  • Server Jobs
  • Job Sequences

Session : 3 – Setting up DataStage Environment

  • DataStage Administrator Properties
  • Defining Environment Variables
  • Importing Table Definitions

Session : 4 – Creating Parallel Jobs

  • Design a simple Parallel job in Designer
  • Compile your job
  • Run your job in Director
  • View the job log
  • Command Line Interface (dsjob)

Session : 5 – Accessing Sequential Data

  • Sequential File stage
  • Data Set stage
  • Complex Flat File stage
  • Create jobs that read from and write to sequential files
  • Read from multiple files using file patterns
  • Use multiple readers
  • Null handling in Sequential File Stage

Session : 6 – Platform Architecture

  • Describe parallel processing architecture Describe pipeline & partition parallelism
  • List and describe partitioning and collecting algorithms
  • Describe configuration files
  • Explain OSH & Score

Session : 7 – Combining Data

  • Combine data using the Lookup stage
  • Combine data using merge stage
  • Combine data using the Join stage
  • Combine data using the Funnel stage

Session : 8 – Sorting and Aggregating Data

  • Sort data using in-stage sorts and Sort stage
  • Combine data using Aggregator stage
  • Remove Duplicates stage

Session : 9 – Transforming Data

  • Understand ways DataStage allows you to transform data
  • Create column derivations using userdefined code and system functions
  • Filter records based on business criteria
  • Control data flow based on data conditions

Session : 10 – Repository Functions

  • Perform a simple Find
  • Perform an Advanced Find Perform an impact analysis
  • Compare the differences between two Table Definitions and Jobs.

Session : 11 – Working with Relational Data

  • Import Table Definitions for relational tables.
  • Create Data Connections.
  • Use Connector stages in a job.
  • Use SQL Builder to define SQL Select statements.
  • Use SQL Builder to define SQL Insert and Update statements.
  • Use the DB2 Enterprise stage.

Session : 12 – Metadata in Parallel Framework:

  • Explain schemas.
  • Create schemas.
  • Explain Runtime Column Propagation (RCP).
  • Build a job that reads data from a sequential file using a schema.
  • Build a shared container.

Session : 13 – Job Control

  • Use the DataStage Job Sequencer to build a job that controls a sequence of jobs.
  • Use Sequencer links and stages to control the sequence a set of jobs run in.
  • Use Sequencer triggers and stages to control the conditions under which jobs run.
  • Pass information in job parameters from the master controlling job to the controlled jobs.
  • Define user variables.
  • Enable restart.
  • Handle errors and exceptions.

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya