DataStage Training

DataStage Training in Chennai

Dhaksha technology, Medavakkam, Chennai is giving the best DataStage training in chennai. We are providing placement focused and real-time training.

Eligibility for the Datastage training – Freshers, 2013 – 2016 passed out and Corporate Employees was working in other technologies

DataStage Training

Like Informatica and Abinitio IBM InfoSphere DataStage is also an ETL tool which can either be deployed in Unix or Windows. Since you can integrate this tool with SAP, SAS, DB2, Oracle etc. you will be having good scope in datastage. It helps you for flexible job design for bulk and complex transformations.

Datastage 11.5 is the latest version.

In previous releases of InfoSphere Information Server, several new stages were introduced to provide better performance and currency for the set of database technologies they cover. In this release, the following older Connectivity stages were removed and fully replaced by their newer counterparts in order to optimize the connectivity infrastructure:

  • DB2 API, DB2 Bulk Load, DB2 zLoad Enterprise Stage
  • DRS
  • Oracle OCI and Oracle OCI Bulk Load
  • Teradata API and Teradata Bulk Load
  • In current release of InfoSphere Information Server, some of the older stages mentioned above are removed. If you are using a connectivity stage that was removed in Version 11.5, you should migrate the connectors before you migrate to Version 11.5 because if you experience any issues with new connectors, you can use the jobs on your old system as a back-up.

Datastage Course Content

Introduction

DataStage Architecture
DataStage Clients
Designer
Director
Administrator

DataStage Workflow

Setting up DataStage Environment
DataStage Administrator Properties
Defining Environment Variables
Importing Table Definitions

Creating Parallel Jobs

Design a simple Parallel job in Designer
Compile your job
Run your job in Director
View the job log
Command Line Interface (dsjob)

Accessing Sequential Data

Sequential File stage
Data Set stage
Complex Flat File stage
Create jobs that read from and write to sequential files
Read from multiple files using file patterns
Use multiple readers
Null handling in Sequential File Stage

Platform Architecture

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

Combining 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

Understand ways DataStage
Create column derivations using user-defined code and system functions
Filter records based on business criteria
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
Types of DataStage Job
Parallel Jobs
Server Jobs
Job Sequences

Job Control

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
Pass information in job parameters from the master controlling job to the controlled jobs
Define user variables
Enable restart
Handle errors and exceptions