Datastage Training

Datastage training covers concepts from the Basic level to the advanced level.  Whether you are an individual or corporate client we can customize training course content as per your requirement.  And can arrange this Datastage training as per your pace.

This DataStage training enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage. This DataStage training will start by covering data Warehousing concepts like Data Acquisition, Data Cleansing, Data Scrubbing, Data Merging, OLTP&OLAP etc and then explain you about types of ETL Tools & Reporting Tools etc.

Then in the next part of the training will give the Introduction to Data Stage where you will learn its features, Ascential suite, Partition & Pipeline parallelism, IBM Web Sphere DataStage&Quality Stage 8.7 Architecture and other related topics. After that this DataStage training will explian you about Data Stage8.7 where you will be explained about Differences between 7.5X2 & 8.7, Parallel Processing environments (SMP, MPP), Information Analyzer Overview and other related topics. 

The next section of this training will cover about Types of Jobs in DataStage and Stages where you will be explained about Difference between server & parallel jobs, Overview of Parallel jobs, Server jobs, Mainframe jobs, migration jobs and job sequencing, Repository, DS Designer toolbar & Palette, Active and Passive stages.

Further this DataSatge training will also cover File Stages, Development Debugging Stages, Relational Stages and Processing Stages. This training wil also cover Real Time & Restructure Stages & Importing & Exporting Data Stage Components, Performance Tuning, Job Control & Job Sequencing Stages. You will be explained about Introduction to Information Analyzer, Quality Stage Stages and Introduction About Web console.

When it comes to Corporate Training, we can say proudly that we have received excellent feedback and appreciation from our corporate clients across the globe. You can reach us for DataStage corporate training and we can even cutomize the training content as per your requirement.

Complete Customization of Datastage training’s course content is possible for Individual students and for Corporate.  Datastage online training is available for individuals and for corporate we may arrange the classroom as well. For more information on Datastage training do connect us.

Our Datastage certified expert consultant will teach on a real-time scenario-based case study and can provide study material and ppt. We will help you to clear your Datastage training certification by providing you with proper guidance. For more details kindly contact us.

When it comes to Datastage Corporate Training, we can say proudly that we have received excellent feedback and appreciation from our corporate clients across the globe. You can reach us for Datastage corporate training and we can even customize the training content as per your requirement.

 Few of the clients we have served across industries are:

 DHL | PWC | ATOS | TCS | KPMG | Momentive | Tech Mahindra | Kellogg's | Bestseller | ESSAR | Ashok Leyland | NTT Data | HP | SABIC | Lamprell | TSPL | Neovia | NISUM and many more.

MaxMunus has successfully conducted 1000+ corporate training in Bangalore / Bengaluru, India, Finland,  Sweden, Germany, USA, UK, Netherlands, Ireland, Austria, Israel, Singapore, Australia, Canada, Denmark, Belgium, Poland, Hong Kong, Qatar, Saudi Arabia, Oman, Denmark, Bahrain, JAPAN, South Korea, UAE, Switzerland,  Kuwait,  Spain, United Kingdom, Russia, Czech Republic, China, Belarus, Luxembourg

Corporate training, Online training, training, course, Online Course, Corporate Course

                                                                                                                     

Course Information

Datastage Course Duration: 30 Hours

Datastage Training Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

Datastage Training Method: Online/Classroom Training

Datastage Study Material: Soft Copy

Course Content

DataStage Training Course Content

Unit-1

Data Warehousing Concepts

  • What is Data Warehouse
  • Enterprise DWH Database Evaluation
  • Data Acquisition
  • Data Cleansing
  • Data Scrubbing
  • Data Merging
  • OLTP&OLAP
  • Types of ETL Tools & Reporting Tools
  • Tables in Data Warehouse
  • Dimension Tables &Fact Tables
  • SCD Type-I, SCD Type-II, SCD Type-III
  • Types of Schemas
  • Data Quality& Data Profiling
  • B-Tree Index& Bit Map Index
  • Differences Between OLTP &Data Warehouse
  • ETL Project Life Cycle

Unit-2

Introduction to DataStage

  • History and Features
  • About Ascential suite
  • Traditional Batch Processing
  • Partition & Pipeline parallelism
  • Partitioning & Re-Partitioning Techniques
  • Combining & Collecting Techniques
  • IBM Web Sphere DataStage&Quality Stage 8.7 Architecture
  • Configuration File & Node Components

Unit-3

About Data Stage8.7

  • Differences between 7.5X2 & 8.7
  • Parallel Processing environments (SMP, MPP)
  • Information Analyzer Overview
  • DataStage & DataStage Quality stage overview
  • Web Console for Information Server

Unit-4

Types of Jobs in Data stage and Stages

  • Difference between server & parallel jobs
  • Overview of Parallel jobs, Server jobs, Mainframe jobs, migration jobs and job sequencing jobs
  • Repository, DS Designer toolbar & Palette
  • Active and Passive stages

Unit-5

File Stages

  • Sequential file Stage
  • Data Set
  • File set & lookup File set
  • Differences between Dataset, File set & Sequential file stage
  • Complex flat file

Unit-6

Development Debugging Stages

  • Row Generator
  • Column Generator
  • Head Stage
  • Tail Stage
  • Sample Stage
  • Peek Stage

Unit-7

Relational Stages

  • Oracle Enterprise
  • ODBC Enterprise
  • Dynamic RDBMS
  • DB2 or UDB Enterprise
  • DB2 Connector
  • Dynamic RDBMS
  • ODBC connector

Unit-9

Processing Stages

  • Aggregator
  • Change Apply
  • Change Capture
  • Compare
  • Compress
  • Copy
  • Decode
  • Difference
  • Encode
  • Expand
  • Filter
  • Funnel
  • Join
  • Look up
  • Merge
  • Modify
  • Pivot
  • Remove Duplicate
  • External Filter
  • Sort
  • Surrogate Key Generator
  • Switch
  • Transformer
  • FTP
  • SCD

Unit-10

Real Time & Restructure Stages& Importing &Exporting Data Stage Components

  • XML Input & XML output stage
  • Column Export and Column Import Stage
  • Importing jobs &Exporting jobs
  • Parameter set
  • Table Definitions

Unit-11

Performance Tuning

  • Environmental Variables
  • Portioning Techniques
  • Techniques for Job Development
  • Data Rules stage
  • Local Container &Shared Container

Unit-12

Job Control & Job Sequencing Stages

  • Job Activity
  • Execute Command Activity
  • Notification Activity
  • Terminator Activity
  • Wait for file Activity
  • End Loop Activity
  • Start loop Activity
  • Sequencer

Unit-13

Introduction About Information Analyzer

  • Column Analysis
  • Base Line Analysis
  • Key Analysis
  • Cross Domain Analysis
  • Data rules &Rule Sets& Bench Mark

Unit-14

Quality Stage Stages

  • Investigate
  • Standardize
  • Data Rules stage
  • Match Frequency
  • AVI Stage
  • Creating User defined rule sets

Unit-15

Introduction About Web console

  • Creating Users in Web Console
  • Assigning List of suite components to the users
  • Creating Users
  • Creating Group

INDIVIDUAL TRAINING BENEFIT

Customize Datastage Course Content as per Individual’s project requirement.

Our Individual Datastage Training program will help employees to start working on the project from day one after the Datastage training completion.

Industry-Specific Subject Matter Experts to provide corporate level Datastage online training to individuals.

Flexibility to choose a schedule for the individual’s to take Datastage online training courses.

Get the Flexibility to learn at your own pace. A Crash course option is also available for the Datastage course.

Flexibility to select a trainer and have a live video session with the trainer before Datastage training actually starts.

MaxMunus will provide Datastage Course Completion Certificate to the participants who are recognized by the industry. It will add value to the corporate workforce.

MaxMunus will help the participants understand the Datastage certification training exam process.

MaxMunus will provide a step-by-step progress assessment of yours.

CORPORATE TRAINING BENEFIT

Customization of Datastage Course Content as per Company’s project requirement.

Our Datastage Corporate Training program will help employees to start working on the project from day one after the training completion.

Industry-Specific Subject Matter Experts will provide Datastage corporate training.

Get Flexibility to choose Location, Mode and Schedule for Datastage corporate training courses.

Flexibility to select corporate the trainer and have a live video session with the trainer before Datastage training actually start.

MaxMunus will provide Course Completion Certificate to the participants which are recognized by the industry. It will add value to the corporate workforce.

MaxMunus will help the participants understand the Datastage certification course exam process.

MaxMunus will provide a step-by-step progress assessment of employees.

Request for demo