IBM InfoSphere DataStage Essentials V8.7 (KM201G)

Course Description Schedule
 

Who should attend

This is a basic course for project administrators and ETL developers responsible for data extraction and transformation using DataStage.

Prerequisites

  • Knowledge of the Windows OS
  • Familiarity with Open Database Connectivity (ODBC) and relational database access technique

Course Objectives

  • Combine data using lookup, join, and merge stages
  • Create jobs that read from and write to sequential files
  • Make jobs that read from and write to a relational database using the connector stages
  • Build jobs that process data using transformations, combinations, filterings, sortings and aggregations
  • Conduct searches and impact analyses
  • Produce job reports
  • Construct DataStage users
  • Administer the DataStage environment

Course Content

  • Deployment
  • Administration console
  • Designer
  • Director
  • Administrator
  • Accessing sequential data
  • Retrieve relational data using connectors
  • Combining data
  • Transforming data
  • Repository
  • Job control
  • Metadata
  • Parallel framework
  • Complex Flat File stage
  • Slowly Changing Dimensions
  • MQ Connector
  • Performance Analyzer and Resource Estimator utilities
Classroom Training

Duration 4 days

Price (excl. tax)
  • Germany: 2,190.- €
  • Switzerland: Fr. 3,374.-
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Bread
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.


Digital courseware Dates and Booking
 
Click on town name to bookSchedule
Germany

Currently no local training dates available.  For enquiries please write to info@flane.de.

Austria
06/03/2017 - 09/03/2017 Vienna (iTLS)