DataStage Online Training

About DataStage

IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition.

About Instructor

DataStage Online Training is provided by a real time consultant. The experience acquired by our trainer on DataStage, is promisingly helpful to the corporate trainee’s. Our instructors are experts in the implementation and support projects.  ASTS always works on real time scenarios. It is extremely useful for the professionals to handle the projects easily in the IT industry.

Prerequisites

  • Graduates/Post Graduates are eligible.
  • Everyone must have knowledge on SQL and PL/SQL.
  • Basic Knowledge on UNIX Shell Scripting.

Terms And Conditions

  • We will Provide Supporting to resolve Student practical Issues.
  • We will provide server Access and 100% Lab Facility.
  • Resume Preparation.
  • Interview Questions & Answers.
  • We will conduct mock interviews. Student also gets 100% supporting before and after getting job.

Course Content

Contents

  • Introduction about Data Stage
  • Datastage Basic Concepts
  • Difference between Server Jobs and Parallel Jobs
  • Difference between Pipeline Parallelisms
  • Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto)
  • Configuration File
  • Difference between SMP/MPD architecture
  • Data Stage Components (Server components/Client Components)
  • Package Installer

Data Stage Administrator

  • Creating project, Editing project and Deleting project
  • Permissions to user
  • .Apt Config file
  • Environment variable creation, permission

Data Stage Director

  • Introduction to Data stage Director
  • Job status View
  • View logs
  • Scheduling
  • Batches Creation

Designer

  • Introduction about Designer
  • Repository
  • Palatte
  • Types of Links
  • File Stages
  • Sequential File
  • Data set File
  • Lookup file set
  • Difference between Sequential file/Dataset/File set
  • Database stages
  • Dynamic RDBMS
  • Oracle Enterprise
  • ODBC Enterprise
  • Stored Procedure

Processing Stages

  • Change Capture (Caption)
  • Compare stage
  • Difference Stage
  • Aggregate Stage
  • Transformer Stage
  • Surrogate Generator Stage
  • Join Generator Stage
  • Merge Generator Stage
  • Lookup Generator Stage
  • Difference between join/Lookup/Merge
  • Difference between join/Lookup
  • Remove Duplicates
  • Switch
  • Pivot
  • Modify
  • Funnel

Debugging Stage

  • Head
  • Tail
  • Pea
  • Row Generator
  • Column Generator
  • Sample
  • Job Parameters

Manager

  • Introduction About Data stage Manager
  • Importing the Job
  • Exporting the Job
  • Importing Table Definition
  • Importing Flat File Definition
  • Routines

Containers

  • Difference between Local Container and Shared Container
  • Local Container
  • Shared Container

 

share this
Top ↑