Hello Folks,

We are offering BEST DATASTAGE ONLINE TRAINING by the industry experts at affordable price.

If anyone interested to take DATASTAGE online training please mail me your details to Satish@o2education.com or call me on +91 9989990935.

IBM WebSphere DataStage and QualityStage – Version 8.1

Unit -1 : 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 .

Unit -2 : 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.

Unit -3 : ETL Design Process

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

Unit -4 : Data Stage Installation

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

Unit – 5 : Introduction to Datastage Version 8.1

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

Unit – 6 :  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 (Orchestrate Engine) – System formats like date, timestamp – Project protect – Version details.

Unit – 7 :  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.

Unit – 8 :  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

Unit – 9 :  Working with Parallel Job Stages

Database Stages

Oracle –  Teradata – ODBC – dynamic RDBMS – DB2

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 –XML Transformer, Java packs, Webservice packs

Local and Shared containers

Unit – 10  Advanced Stages in Parallel Jobs (Version 8.1)

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.

Unit – 11 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

Unit – 12 Information Analyzer

IBM WebShpere Information Analyzer overview – Data Profiling process – Column analysis – Primary key analysis – Foreign key analysis – Cross-domain analysis – Baseline analysis – Aanalysis result publication – Deleting statistics reports – Baseline analysis reports – Cross-domain analysis summary statistics reports – Beseline analysis reports – Cross-domain analysis reports – Primary key reports – Foregin key analysis reports.

Unit – 13 WebShpere Quality Stage

About Data Quality – Datastage quality stages – Investigate stage – Standardize stage Match Frequency stage – Unduplicate Match stage – Reference Match Stage – Survive stage.

Unit – 14 IBM Information Server Administration Guide

IBM WebSphere DataStage administration – Opening the IBM Information Server Web console – Creating users in the console – Assigning security roles to users and groups – Managing licenses – Managing active sessions – Managing logs – Managing schedules – Backing up and restoring IBM Information Server.