> > > KM201G

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
  • Fresh fruits
  • Lunch in a nearby restaurant

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


Digital courseware Dates and Booking
 
Schedule

Currently there are no training dates scheduled for this course.  Enquire a date