Datastage Online Training

 

Datastage Online Training

Datastage Online Training

Purpose
Audience
Prerequisites to learn DATASTAGE
Objectives

              IBM InfoSphere DataStage Essentials v 11X

Duration: 25 Hours

DataStage 11X

Unit 1. Introduction to DataStage.

  • Unit objectives
  • What is DataStage?
  • What is IBM InfoSphere DataStage?
  • What is Information Server?
  • Information Server backbone
  • Information Server Web Console
  • DataStage architecture
  • DataStage Clients
  • DataStage Administrator.
  • DataStage Designer.
  • DataStage Director. .
  • Developing in DataStage.
  • DataStage project repository.
  • Types of DataStage jobs
  • Design elements of parallel jobs.
  • Job Parallelism.
  • Pipeline parallelism
  • Partition parallelism.
  • Three-node partitioning. .
  • Job design versus execution.
  • Configuration file. .
  • Example Configuration File
  • Unit summary.

Unit 2. Deployment.

  • Unit objectives.
  • What gets deployed?
  • Deployment: Everything on one machine.
  • Deployment: DataStage on separate machine.
  • Information Server Startup.
  • Information Server start-up.
  • Starting Information Server on Windows.
  • Verifying that Information Server is running. .
  • Web Console Login Window.
  • Exercise 1. Log into the Information Server Web Console.
  • Unit summary.

Unit 3. DataStage Administration.

  • Unit objectives.
  • Managing DataStage Users.
  • Information Server Web Console – Administration.
  • Opening the Administration Web Console. .
  • User and Group Management.
  • Assigning DataStage roles. .
  • DataStage credentials
  • DataStage Administrator
  • Logging onto DataStage Administrator
  • DataStage Administrator Projects Tab.
  • DataStage Administrator General tab
  • Environment variables.
  • Environment reporting variables.
  • DataStage Administrator Permissions tab
  • Adding users and groups.
  • Specify DataStage role. .
  • DataStage Administrator Logs tab.
  • DataStage Administrator Parallel tab.
  • Exercise 2. Administering DataStage.
  • Unit summary.

Unit 4. Working With Metadata.

  • Unit objectives.
  • Logging onto Designer.
  • Designer work area.
  • DataStage Import / Export
  • Repository window.
  • Import and export.
  • Export procedure
  • Export window
  • Import procedure.
  • Import options.
  • Importing Table Definitions.
  • Source and target metadata
  • Sequential file import procedure.
  • Importing sequential metadata.
  • Sequential import window.
  • Specify format
  • Edit column names and types
  • Extended properties window
  • Table definition in the repository
  • Exercise 3. Importing and exporting DataStage objects.
  • Exercise 4. Import a table definition.
  • Unit summary.

Unit 5. Creating Parallel Jobs.

  • Unit objectives
  • What is a parallel job?
  • Job development overview.
  • Tools Palette.
  • Adding stages and links.
  • Job creation example sequence
  • Create a new parallel job.
  • Drag stages and links from the Palette.
  • Renaming links and stages.
  • Row Generator stage
  • Inside the Row Generator stage
  • Row Generator Columns tab.
  • Extended properties.
  • Peek stage.
  • Peek stage properties.
  • Job parameters
  • Defining a job parameter
  • Using a job parameter in a stage
  • Annotation stage properties
  • Compiling and running a job.
  • Errors or successful message
  • Running Jobs and Viewing the Job Log.
  • DataStage Director
  • Run options
  • Performance statistics
  • Director Status view
  • Job log, viewed from Designer
  • Message details.
  • Other job log functions
  • Director monitor
  • Parameter Sets and Values Files.
  • Parameter sets
  • Creating a parameter set.
  • Defining the parameters.
  • Defining values files.
  • Loading a parameter set into a job.
  • Using parameter set parameters.
  • Running jobs with parameter set parameters.
  • Checkpoint
  • Exercise 5. Creating parallel jobs.
  • Unit summary

Unit 6. Accessing Sequential Data. .

  • Unit objectives.
  • Sequential File Stage.
  • How sequential data is handled.
  • Features of the Sequential File stage.
  • Sequential file format example . . .
  • Job design with Sequential File stages. .
  • Sequential File stage properties.
  • Format tab.
  • Columns tab.
  • Reading sequential files using a file pattern.
  • Multiple readers.
  • Writing to a sequential file
  • Reject Links. .
  • Source and target reject links.
  • Setting the Reject Mode property.
  • Copy Stage.
  • Copy stage example
  • Copy stage Mappings
  • Exercise 6. Reading and writing to sequential files.
  • Reading and Writing Null Values to a Sequential File.
  • Working with nulls.
  • Specifying a value for null.
  • Viewing data with nulls
  • Exercise 7. Reading and writing null values
  • Data Set Stage.
  • Job with a target Data Set stage
  • Data Set Management utility
  • Data and schema displayed
  • Exercise 8. Working with data sets.
  • Checkpoint solutions.

Unit 7. Partitioning and Collecting.

  • Unit objectives.
  • Partitioning
  • Stage partitioning
  • Round Robin and Random partitioning.
  • Entire partitioning.
  • Hash partitioning. .
  • Modulus partitioning
  • Auto partitioning. .
  • Specifying Stage Partitioning
  • Partitioning / Collecting link icons
  • Configuration file.
  • Example configuration file.
  • Adding $APT_CONFIG_FILE as a job parameter
  • Parallel job compilation. .
  • Exercise 9. Partitioning and collecting.
  • Unit summary.

Unit 8. Combining Data.

  • Unit objectives.
  • Combining data.
  • Lookup, Join, Merge stages.
  • Lookup Stage. .
  • Lookup Stage features.
  • Lookup types.
  • Equality match Lookup stage example
  • Lookup stage with an equality match
  • Defining the Lookup key
  • Specifying the output columns
  • Lookup failure actions
  • Specifying lookup failure actions
  • Lookup stage with reject link
  • Lookup stage behavior…
  • Lookup stage output.
  • Exercise 10.
  • Range Lookups
  • Range Lookup stage job
  • Range on reference link.
  • Selecting the stream column.
  • Range expression editor.
  • Range on stream link
  • Specifying the range lookup
  • Range expression editor
  • Exercise 11. Range lookups.
  • Join Stage.
  • Join stage.
  • Job with Join stage
  • Join stage properties
  • Output Mapping tab
  • Join stage behavior
  • Inner join output
  • Left outer join output.
  • Right outer join output
  • Full outer join
  • Merge Stage.
  • Merge stage
  • Merge stage job
  • Merge stage properties
  • No title.
  • Funnel Stage
  • What is a Funnel stage?
  • Funnel stage example.
  • Funnel stage properties.
  • Exercise 12. Using Join, Merge, and Funnel stages. .
  • Unit summary.

Unit 9. Group Processing Stages.

  • Unit objectives.
  • Group processing stages. .
  • Sort Stage.
  • Sorting data Sorting alternatives.
  • In-Stage sorting.
  • Stable sort illustration. .
  • Sort stage Properties tab.
  • Specifying the sort keys.
  • Sort options.
  • Create key change column.
  • Partition sorts
  • Aggregator Stage.
  • Aggregator stage.
  • Job with Aggregator stage
  • Aggregation types.
  • Count Rows aggregation type
  • Output Mapping tab
  • Output Columns tab.
  • Calculation aggregation type.
  • Grouping methods
  • Method = Hash.
  • Method = Sort.
  • Remove Duplicates Stage.
  • Removing duplicates.
  • Remove Duplicates stage job. .
  • Remove Duplicates stage properties.
  • Checkpoint
  • Checkpoint solutions…
  • Fork-Join Job Design
  • Unit summary.

Unit 10. Transformer Stage.

  • Unit objectives.
  • Introduction to the Transformer Stage.
  • Transformer stage
  • Job with a Transformer stage.
  • Inside the Transformer stage
  • Transformer stage elements – 1
  • Transformer stage elements – 2
  • Constraints
  • Constraints example.
    • Defining a constraint.
    • Using the expression editor
    • Otherwise links for data integrity
    • Otherwise link example
    • Specifying the link ordering.
    • Specify the otherwise link constraint
    • Exercise 14. Defining a constraint.
    • Derivation targets.
    • Stage variables.
    • Stage variable definitions
    • Building a derivation
    • Defining a derivation.
    • IF THEN ELSE derivation
    • String functions and operators.
    • Null Handling in the Transformer.
    • Null handling.
    • Unhandled nulls.
    • Legacy null processing.
    • Transformer stage reject link. .
    • Exercise 15. Define derivations.
    • Loop Processing.
    • Loop processing
    • Functions used in loop processing
    • Loop processing example
    • Loop processing example job
    • Inside the Transformer stage.
    • Exercise 16. Loop processing.
    • Transformer Group Processing. .
    • Group processing . . .
    • Group processing example.
    • Job results.
    • Transformer logic.
    • Looping through saved input rows.
    • Example job results
    • Transformer logic
    • Parallel Job Debugger
    • Parallel job debugger.
    • Setting breakpoints.
    • Editing breakpoints. .
    • Running a parallel job in the debugger
    • Adding columns to the watch list. .
    • Exercise 17. Group processing / PX Debugger
    • .Unit summary

Unit 11. Repository Functions. .

  • Unit objectives . . . .
  • Searching the Repository. .
  • Quick find . . . .
  • Found results.
  • Advanced Find window
  • Advanced Find options.
  • Using the found results.
  • Impact Analysis.
  • Performing an impact analysis
  • Record ordering property.
  • Reject link specification.
  • Exercise 20. Connector stages with multiple input links.
  • Building a Query Using SQL Builder.
  • SQL Builder
  • Table definition Locator tab.
  • Opening SQL Builder.
  • SQL Builder window
  • Creating a calculated column
  • Constructing a WHERE clause.
  • Sorting the data.
  • Viewing the generated SQL
  • Exercise 21. Construct SQL using SQL Builder.
  • Unit summary.

Unit 13. Job Control. .

  • Unit objectives. .
  • What is a job sequence?
  • Basics for creating a job sequence. .
  • Job sequence stages.
  • Job sequence example.
  • Job sequence properties.
  • Job Activity stage properties.
  • Job Activity trigger.
  • Execute Command stage.
  • Notification Activity stage
  • User Variables stage
  • Referencing the user variable.
  • Flow of Control Stages.
  • Wait for File stage
  • Sequencer stage. .
  • Nested Condition stage.
  • Loop stages
  • Error Handling. .
  • Handling activities that fail
  • Exception Handler stage.
  • Enable restart.
  • Disable checkpoint for a Stage.
  • Exercise 22. Build and run a job sequence. .
  • Unit summary.

Unit 10. Transformer Stage.

  • Unit objectives.
  • Introduction to the Transformer Stage.
  • Transformer stage
  • Job with a Transformer stage.
  • Inside the Transformer stage
  • Transformer stage elements – 1
  • Transformer stage elements – 2
  • Constraints
  • Constraints example.
  • Defining a constraint.
  • Using the expression editor
  • Otherwise links for data integrity
  • Otherwise link example
  • Specifying the link ordering.
  • Specify the otherwise link constraint
  • Exercise 14. Defining a constraint.
  • Derivation targets.
  • Stage variables.
  • Stage variable definitions
  • Building a derivation
  • Defining a derivation.
  • IF THEN ELSE derivation
  • String functions and operators.
  • Null Handling in the Transformer.
  • Null handling.
  • Unhandled nulls.
  • Legacy null processing.
  • Transformer stage reject link. .
  • Exercise 15. Define derivations.
  • Loop Processing.
  • Loop processing
  • Functions used in loop processing
  • Loop processing example
  • Loop processing example job
  • Inside the Transformer stage.
  • Exercise 16. Loop processing.
  • Transformer Group Processing. .
  • Group processing . . .
  • Group processing example.
  • Job results.
  • Transformer logic.
  • Looping through saved input rows.
  • Example job results
  • Transformer logic
  • Parallel Job Debugger
  • Parallel job debugger.
  • Setting breakpoints.
  • Editing breakpoints. .
  • Running a parallel job in the debugger
  • Adding columns to the watch list. .
  • Exercise 17. Group processing / PX Debugger
  • Unit summary

Unit 11. Repository Functions. .

  • Unit objectives . . . .
  • Searching the Repository. .
  • Quick find . . . .
  • Found results.
  • Advanced Find window
  • Advanced Find options.
  • Using the found results.
  • Impact Analysis.
  • Performing an impact analysis
  • Record ordering property.
  • Reject link specification.
  • Exercise 20. Connector stages with multiple input links.
  • Building a Query Using SQL Builder.
  • SQL Builder
  • Table definition Locator tab.
  • Opening SQL Builder.
  • SQL Builder window
  • Creating a calculated column
  • Constructing a WHERE clause.
  • Sorting the data.
  • Viewing the generated SQL
  • Exercise 21. Construct SQL using SQL Builder.
  • Unit summary.

Unit 13. Job Control. .

  • Unit objectives. .
  • What is a job sequence?
  • Basics for creating a job sequence. .
  • Job sequence stages.
  • Job sequence example.
  • Job sequence properties.
  • Job Activity stage properties.
  • Job Activity trigger.
  • Execute Command stage.
  • Notification Activity stage
  • User Variables stage
  • Referencing the user variable.
  • Flow of Control Stages.
  • Wait for File stage
  • Sequencer stage. .
  • Nested Condition stage.
  • Loop stages
  • Error Handling. .
  • Handling activities that fail
  • Exception Handler stage.
  • Enable restart.
  • Disable checkpoint for a Stage.
  • Exercise 22. Build and run a job sequence. .
  • Unit summary.

 

Fill up quick inquiry form to get more details on Datastage online training

Click here to register for the Datastage Online Training.

Click here to register for the Datastage Online Training.

About our Datastage online training instructor:

  • Working in the Top MNC
  • Got 8+ years of experience
  • Trained more than 300+ candidates online
  • Working on BI and ETL tool
  • Expertise in exclusive DATASTAGE 11.3 Training
  • Datastage Interview Questions
  • Hands on DATASTAGE online training

Click here to register for the Datastage Online Training.