All Courses

One to One Training

Get 1-to-1 Live Instructor Led Online Training in flexible timings

Program Fees:  28,000 Discount Price: 25,000

You Save:  3,000 (10.7% OFF)

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Program Fees:  23,000 Discount Price: 20,000

You Save:  3,000 (13% OFF)

About Datastage Online Training

What is this course about?

This course gives you a clear understanding of how to use DataStage. Even a non-programming and IT background can learn this DataStage training.

What are the course objectives?

Every Day, we start our life real-time data for with any of the following transaction Bank transactions, Insurance domain, Logistics, Telecom, retail, Call center calls, Dynamic data. Every information is captured in files, Database, XML files, Data files, Unix files, etc. These data are processed into databases for analytical purpose. Every day data are collected with triples the amount. Now the Infosphere Information server (Datastage) is used to process those unstructured data.

Who should do this course?

This training will be suitable for,

  • Working IT professionals
  • Job Seekers
  • Who wants to change their work area.

Prerequisite: Knowledge in computers and understanding about basic programs.

Job Opportunity for Datastage?

Datastage is one of the efficient tools in markets for processing the data. There are tremendous opportunities in the IT sector who are ready to pay high packages. Come grab them with both hands!!!

Course Duration Information

This DataStage training will happen for 25 hours. If you opt for weekend classes both Saturday and Sunday you will be having approximately 2 hours 30 mins in the scheduled time of the batch you chose. If you opt for weekdays classes all Monday to Friday you need to spend at least 90mins.

What you'll learn from this course?

  • Datastage Introduction
  • Datastage Overview
  • Types of DataStage Job
  • Datastage Administrator
  • Server Jobs
  • Parallel Jobs
  • Partitioning techniques
  • Sequential or unstructured data
  • Configuration files
  • Grouping Data
  • Sorting and Aggregating Data
  • Transforming Data
  • Repository Functions
  • Working with Relational Data
  • Metadata in Parallel Framework
  • Flow or Controlling Jobs
  • Advanced Features

Upcoming Batches for Datastage Training

Our Datastage Online Course gives students the opportunity to take classes on your flexible timings. Choose from a number of batches as per your convenience. If you got something urgent to do, reschedule your batch for a later time. The classes can be attended to at any place and at any time as per your choice.

Course Price at

Program Fees:  23,000 Discount Price: 20,000

You Save:  3,000 (13% OFF)

Calender

Can’t find a batch you were looking for?

Request a Batch

Datastage Training Syllabus

Datastage Introduction

Datastage Overview

  • Datastage History
  • DataStage Architecture
  • Datastage Topology
  • DataStage Components
  • Server Components
  • Client Components
  • DataStage Workflow

Types of DataStage Job

  • Parallel Jobs
  • Server Jobs
  • Job Sequences

Datastage Administrator

  • Creating Projects
  • Enabling RCP
  • Overview of Other Mandatory properties

Server Jobs

  • Creating simple server job
  • Monitoring the jobs at runtime
  • Transformer and lookups
  • Stage variables

Parallel Jobs

  • Parallel job overview
  • Implementing Pipelining and Paralleling techniques in jobs
  • Compile and trigger the job in Director
  • View the job log
  • Sub routines

Partitioning techniques

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

Sequential or unstructured data

  • Sequential File stage
  • Data Set stage
  • File Set stage
  • Complex Flat File stage
  • Fixed length and Variable length files
  • Create jobs that read from and write to sequential files
  • Read from multiple files using file patterns
  • Null handling in Sequential File Stage
  • Handling Excel sheets, .csv files

Configuration files

  • Overview of Configuration files
  • Node concepts
  • Conductors, Section leaders and Players
  • Creating Configuration files

Grouping Data

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

Sorting and Aggregating Data

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

Transforming Data

  • Transforming the data with Constraints, Derviation
  • Column derivations using user defined code and system functions
  • Filter records based on business logic
  • Control data flow based on data conditions

Repository Functions

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

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

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

Flow or Controlling Jobs

  • 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
  • Define user variables
  • Enable restart
  • Handle errors and exceptions
  • Custom Job triggers in Sequence job

Advanced Features

  • Run-Time column propagation(RCP)
  • Multiple Instances
  • Sub Routines
  • Command Line
  • Implementing Parameter in Jobs
  • Creating Parameters set
  • Standardization of DS Job
  • Etiquettes in Job Designing
Request Syllabus

Are you Looking for Customized Syllabus

We are also providing customized syllabus to the students according to their needs and projects requirements for the cons

Request a Call

Program Features

IT Professionals as Trainers

Learning a technology with a professional who is well expertise in that solve 60% of your needs.

Fully Hands-on Training

We support any training should be more practical apart from theoretical classes. So, we always gives you hands-on training.

Affordable Fees

We are dead cheap in fees. We are having options to make the payment in instalments as well if needed.

10000+ old students to believe

We satisfied 10000+ students from the day we started GangBoard. Take a look of our old student’s video reviews and it says all.

Counselling by Experts

If you are in dilemma to choose a course, we are having experts in counselling team to help you with perfect projection of your career.

Own Course Materials

We have every course material to understand which is prepared by our trainers and we will share with you after session completes.

FAQ

Detailed installation of required software will be displayed in your LMS. Our support team will help you to setup software if you need assistance. Hardware requirements need to be fulfilled by participants.

No worries. It might happen. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. And if required you can even attend that topic if any other live batches.

Top-notch professionals in that field who understands how to convey things in technical as well as subject matter experts.

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through “Quick Enquiry”, “Live Chat” or “Request Call-back” channels.

Payments can be made using any of the following options and a receipt of the same will be issued to you automatically via email. Debit Card / Credit Card, American Express, Master Card, or PayPal.

You can reach us through +91-9707240250. Or you can share your queries through enq@gangboard.com. Estimated turnaround time will be 24 hours for emails.

Request more information

Our Advisor will get in touch with you in the next 24 Hours

Call Us: +91-9707 240 250

Datastage Exams & Certification

GangBoard Certification is Accredited by all major Global Companies around the world. We provide after completion of the theoretical and practical sessions to fresher’s as well as corporate trainees.

Our certification at GangBoard is accredited worldwide. It increases the value of your resume and you can attain leading job posts with the help of this certification in leading MNC’s of the world. The certification is only provided after successful completion of our training and practical based projects.

5000

Total Number of Reviews

4.57

Aggregate Review Score

97%

Course Completion Rate

At the end of our course, you will be assigned to work a real-time project. Once you completed the assigned project with expected results we (Experts Team from GangBoard) will verify and issue a DataStage Certificate. If you are not able to deliver expected results in the project we will support you by clarifying doubts and help you to re-attempt the project.

Datastage Training Reviews

Average Ratings

Activity from April 2018

4.8

Course Reviews

Activity from Last Year

1596 Reviews

Average Ratings

GangBoard Total Reviews in all Medium

21,596 Reviews

Related Blogs: