DATASTAGE 11.5

This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage. Students will learn to create parallel jobs that access sequential and relational data and combine and transform the data using functions and other job components.

2567 Satisfied Learners

Best Training IBM WebSphere DataStage   11.5

Duration of  Training : 6 weekends / 40 Hrs

Trainer is having 10 + years of experience in IT Industry.

——————————————————————————————————————————–

SYLLABUS
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 Modelling – Entity Relationship model (E-R model) – Data Modelling 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 11.5
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 – Environment 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 11.5)
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 WebSphere 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 WebSphere 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.

IBM InfoSphere DataStage Essentials (v11.5)

12+ Year Experienced Real Time Trainer

We deliver training from Industry level Experts having experience in range of 8-20 years with well furnished & well equipped infrastructure in Pune.
We also promise “Hands-on” Practical Demo & Training sessions based on “Real-time Production Scenario” on latest & technology driven courses. We believe in delivering knowledge while sessions to improve Interview skills.

IBM InfoSphere Advanced DataStage – Advanced Data Processing V9.1
IBM InfoSphere Advanced DataStage – Parallel Framework v11.5
IBM InfoSphere Data stage and Quality stage

Our Courses

Drop A Query