DataStage Training

  • (4.9)
  • 5764 Ratings
  • Learners : 5789
Try Live Demo

Trusted By Companies Worldwide & 3,50,850+ Learners

DataStage Course Overview

Tekslate’s IBM DataStage training will make you an expert in creating parallel DataStage jobs to implement business intelligence in any given environment. You will also be provided with the implementation of two real-time DataStage projects under the guidance of highly experienced trainer during training which will help you in clearing IBM DataStage Certification.  
Course Duration 30 hrs
Live Projects 2
Next Batch 21 Nov, 2019
23 Nov, 2019
26 Nov, 2019

DataStage Course Curriculum

  • Introduction to the IBM Information Server Architecture
  • The Server Suite components
  • The various tiers in the Information Server.
     
  • Understanding the IBM InfoSphere DataStage
  • The Job life cycle to develop, test, deploy and run data jobs
  • high-performance parallel framework
  • real-time data integration.
     

Introduction to the design elements, various DataStage jobs, creating a massively parallel framework, scalable ETL features, working with DataStage jobs.
 

  • Understanding the DataStage Job
  • creating a Job that can effectively extract, transform and load data
  • cleansing and formatting data to improve its quality.
     
  • Learning about data parallelism – pipeline parallelism and partitioning parallelism
  • Two types of data partitioning – Key-based partitioning and Keyless partitioning
  • Detailed understanding of partitioning techniques like round robin, entire, hash key, range, DB2 partitioning, data collecting techniques and types like round robin, order, sorted merge and same collecting methods.
     
  • Understanding the various job stages – data source, transformer, final database, the various parallel stages – general objects, debug and development stages, processing stage, file stage types, database stage, real-time stage, restructure stage, data quality and sequence stages of InfoSphere DataStage.
     
  • Understanding the parallel job stage editors
  • The important types of stage editors in DataStage.
     
  • Working with the Sequential file stages
  • understanding runtime column propagation
  • working with RCP in sequential file stages
  • using the sequential file stage as a source stage and target stage.
     
  • Understanding the difference between dataset and Fileset and how DataStage works in each scenario.
     
  • Creating a sample DataStage job using the dataset and Fileset types of data.
     

Learning about the various properties of the Sequential File Stage and Dataset stage.
 

  • Creating a lookup file set, working in parallel or sequential stage, learning about single input and an output link.
     
  • Studying the Transformer Stage in DataStage, the basic working of this stage, characteristics -single input, any number of outputs and reject link, how it differs from other processing stages, the significance of Transformer Editor, and evaluation sequence in this stage.
     
  • Deep dive into Transformer functions – String, type conversion, null handling, mathematical, utility functions
  • understanding the various features like a constraint, system variables, conditional job aborting, Operators and Trigger Tab.
     
  • Understanding the looping functionality in Transformer Stage, output with multiple rows for single input row, the procedure for looping, loop variable properties.
     
  • Connecting to the Teradata Enterprise Stage
  • properties of the connection.
     
  • Generating data using Row Generator sequentially in a single partition
  • configuring to run in parallel.
     
  • Understanding the Aggregator Stage in DataStage
  • The two types of aggregation – hash mode and sort mode.
     
  • Deep learning of the various stages in DataStage, the importance of Copy, Filter and Modify stages to reduce the number of Transformer Stages.
     
  • Understanding Parameter Set, storing DataStage and Quality Stage job parameters.
  • Default values in files, the procedure to deploy Parameter Sets function and its advantages.
     
For Individuals
For Corporates

DataStage Upcoming Batches

  • Weekend

    21 Nov - 21 Dec

    7:00 AM IST
  • Weekday

    23 Nov - 23 Dec

    7:00 AM IST
  • Weekend

    26 Nov - 26 Dec

    7:00 AM IST
  • Weekday

    28 Nov - 28 Dec

    7:00 AM IST
  • Weekend

    1 Dec - 31 Dec

    7:00 AM IST
  • Weekday

    5 Dec - 04 Jan

    7:00 AM IST
  • Schedules Doesn't Suit You ?

    Our Team can set up a batch at your convinient time.

    Let us know

    DataStage Course Objectives

    After completion of IBM DataStage training at Tekslate, you will be able to

    • Get an overview of IBM Information Server architecture and how DataStage fits within it.
    • Describe the Information Server and DataStage deployment options.
    • Use the Information Server Web Console and the DataStage Administrator client to create DataStage users and to configure the DataStage environment.
    • Import and export DataStage objects to a file.
    • Understand the various job stages of InfoSphere DataStage.
    • Design, compile, run, and monitor DataStage parallel jobs.
    • Design jobs that read and write to sequential files.
    • Design jobs that combine data using joins and lookups.
    • Implement complex business logic using the DataStage Transformer stage.
    • Debug DataStage jobs using the DataStage PX Debugger.
       
    • Many top companies have started using IBM InfoSphere DataStage in their deployments.
    • IBM DataStage developers are earning quite more salaries compared to professionals working on other technologies.
    • The average pay for IBM DataStage developers is $121,762 USD per annum.
    • Due to the high demand for IBM DataStage, there are numerous job opportunities available around the world.
       

    The following job roles will get benefited from learning this course:

    • Software Developers and Architects. 
    • Project administrators and ETL developers responsible for data extraction and transformation using DataStage.
    • IT professionals
    • Aspirants looking for a career in Business Intelligence.
       

    There are no specific prerequisites for learning this course. Anyone who is interested to build their career in Business Intelligence domain can join this training.

    • Participant having basic knowledge of databases and ETL concepts will be an added advantage.
       

    We will provide two real-time projects under the guidance of a professional trainer, who will explain to you how to acquire in-depth knowledge on all the concepts involved in these projects.
     

    Have More Questions

    Contact us

    DataStage Course FAQ's

    Have questions? We’ve got the answers. Get the details on how you can grow in this course.

    We have a strong team of professions who are experts in their fields. Our trainers are highly supportive and render a friendly working environment to the students positively stimulating their growth. 
     

    We will share you the missed session from our recordings. We at Tekslate maintains a recorded copy of each live course you undergo.
     

    Our Trainers will provide the student with the Server Access ensuring practical real-time experience and training with all the utilities required for the in-depth understanding of the course.
     

    We provide all the training sessions LIVE using either GoToMeeting or WebEx, thus promoting one-on-one trainer student Interaction.
     

    Live training uncovers distinct benefits as they are mighty to reach your desired audience converting your prospects into customers in less time. Pre-recorded videos offer plenty of advantages for entrepreneurs to educate entertain and inspire your audience as long as you want.
     

    You can contact our Tekslate support team, or you can send an email to info@tekslate.com for your queries.
     

    Yes. We provide the course materials available after course completion.
     

    There exist some discounts for weekend batches and group participants if the joiners are more than 2.
     

    If you are enrolled in classes and have paid fees but want to cancel the registration for any reason, we will attain you in 48 hours will be processed within 30 days of prior request.
     

    Have More Questions. Reach our Support Team

    Contact us

    Join a Free DataStage Demo Session

    See if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate

    Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in DataStage

    By providing us with your details, We wont spam your inbox.