Datastage Training in Chennai

Datastage Training in Chennai

Guys, now you got an opportunity to get aligned yourselves what IT or Data Analytics companies needed. All industry needs is data should be properly processed with efficient tools like Datastage. We give training in Datastage 8.7, 9.1, 11.3 version, Datastage architecture, Configuration files, Node concepts, Datastage Topologies, partition techniques, RCP, Multiple Instance, Routines, Environment variables, etc.

Fill This Form For Demo Class

About Course

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

Course objectives                             

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

Who can learn this course?

This training will be suitable for,

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

Job Opportunity

Datastage is one of the efficient tools in markets for processing the data. There is tremendous opportunity in 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 scheduled time of the batch you chose. If you opt for weekdays classes all Monday to Friday you need to spend at-least 90mins.

Course 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 of Director
  • View the job log
  • Subroutines

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, Deviation
  • 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

Good place to learn selenium. Found them online and joined classroom training. Trainers are experienced working professionals, explained all syllabus and nice environment to learn

Gayathri Kumar

Selenium Training, Working in CTS

Our Trending Courses

Fill this form for call back