Search for Training

Data Stage

Have Queries? Ask us +91 72592 22234

Course Overview

Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Data Stage which gives you the opportunity to interact with a Data Stage instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content

Data Warehouse Fundamentals

  • An introduction to Data Warehousing
  • Purpose of Data Warehouse
  • Data Warehouse Architecture
  • Operational Data Store
  • OLTP Vs Warehouse Applications
  • Data Marts Data marts Vs Data Warehouses
  • Data Warehouse Life cycle .

Data Modelling

  • Introduction to Data Modeling
  • Entity Relationship model (E-R model)
  • Data Modeling for Data Warehouse
  • Dimensions and fact tables
  • Star Schema and Snowflake Schemas.

ETL Design Process

  • Introduction to Extraction,
  • Transformation & Loading
  • Types of ETL Tools
  • Key tools in the market .

Data Stage Installation

  • Data stage Installation
  • Prerequisites to install Data stage
  • Installation process.

Introduction to Datastage Version 

  • Datastage introduction
  • IBM information Server architecture
  • DataStage components
  • DataStage main functions
  • Client components.

Datastage Administrator

  • Datastage project Administration - Editing projects and Adding Projects
  • Deleting projects Cleansing up project files
  • Global variable setting – Environement management
  • Auto purging – Rutime Column Propagation(RCP)
  • Add checkpoints for sequencer – NLS configuration
  • Generated OSH (Orchestra Engine) – System formats like data, 
  • timestamp – Project protect – Version details.

Datastage Director

  • Introduction to Datastage Director – Validating Datastage Jobs
  • Executing Datastage jobs – Job execution status
  • Monitoring a job – Job log view – job scheduling
  • Creating Batches – Scheduling batches.

Datastage Designer

  • Introduction to Datastage Designer – Importance of Parallelism
  • Pipeline Parallelism – Partition Parallelism
  • Partitioning and collecting - Partition techniques
  • Datastage Repository Palette – Passive and Active stages
  • Job design overview – Designer work area
  • Annotations – Creating jobs – Importing flat file definitions
  • Dataset Overview

Working with Parallel Job Stages

  • Database Stages
  • Oracle – Teradata – ODBC – dynamic RDBMS

File Stages

  • Sequential file – Dataset – File set – Lookup file set.

Processing Stages

  • Copy – Filter – Funnel – Sort Remove duplicate
  • Aggregator – Modify – Compress – Expand – Decode
  • Encode – Switch – Pivot stage – Lookup
  • Join – Merge – difference between look up,
  • join and merge – change capture – Change apply
  • Compare – Difference – Surrogate key generator
  • Transformer.

Debug Stages

  • Head – Tail – Peek – Column generator
  • Row generator .

Real Time Stages

  • XML input – XML output , Java packs,
  • Webservice packs

Local and Shared containers 

Advanced Stages in Parallel Jobs 

  • Range Look process – Surrogate key generator stage
  • Slowly changing dimension stage – iway stage
  • FTP stage – Java plug in – Job performance analysis
  • Resource estimation
  • Slowly Changing Dimensions implementation
  • Performance tuning.

Job Sequencers

  • Arrange job activities in Sequencer
  • Triggers in Sequencer – Restablity
  • Recoverability – Notification activity
  • Terminator activity
  • Wait for file activity Start Look activity
  • Execute Command activity – Nested Condition activity
  • Exception handling activity – User Variable activity
  • End Loop activity – Adding Checkpoints

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234