Datastage training

[kumar1234]

IBM WebSphere DataStage and QualitySt age – Version 8.1
Unit -1 : Data Warehouse Fundament als
An introduct ion to Data Warehousi ng – purpose of Data Warehouse – Data Warehouse Architect ure – Operation al Data Store – OLTP Vs Warehouse Applicati ons – Data Marts Data marts Vs Data Warehouse s – Data Warehouse Life cycle .
Unit -2 : Data Modelling
Introduct ion to Data Modeling – Entity Relations hip model (E-R model) – Data Modeling for Data Warehouse – Dimension s and fact tables – Star Schema and Snowflake Schemas.
Unit -3 : ETL Design Process
Introduct ion to Extractio n, Transform ation & Loading-  Types of ETL Tools – Key tools in the market .
Unit -4 : Data Stage Installat ion
Data stage Installat ion – Prerequis ites to install Data stage – Installat ion process.
Unit – 5 : Introduct ion to Datastage Version 8.1
Datastage introduct ion – IBM informati on Server architect ure –– DataStage component s – DataStage main functions – Client component s.


Please reply to [email protected]  if interested
Unit – 6 :  Datastage Administr ator
Datastage project Administr ation =- Editing projects and Adding Projects – Deleting projects Cleansing up project files – Global variable setting – Environem ent managemen t – Auto purging – Rutime Column Propagati on(RCP) – Add checkpoin ts for sequencer – NLS configura tion – Generated OSH (Orchestra Engine) – System formats like data, timestamp – Project protect – Version details.
Unit – 7 :  Datastage Director
Introduct ion to Datastage Director – Validatin g Datastage Jobs – Executing Datastage jobs – Job execution status – Monitorin g a job – Job log view – job schedulin g – Creating Batches – Schedulin g batches.
Unit – 8 :  Datastage Designer
Introduct ion to Datastage Designer – Importanc e of Paralleli sm – Pipeline Paralleli sm – Partition Paralleli sm – Partition ing and collectin g – Symmetric Multi Pro9cessi ng (SMP) Massively Parallel Processin g (MPP) – Partition technique s – Datastage Repositor y Palette – Passive and Active stages – Job design overview – Designer work area – Annotatio ns – Creating jobs – Importing flat file definitio ns – Managing the Metadata environme nt – Dataset managemen t – Deletion of Dataset – Routines – Arguments .
Unit – 9 :  Working with Parallel Job Stages
Database Stages
Oracle –  Teradata – ODBC – dynamic RDBMS
File Stages
Sequentia l file – Dataset – File set – Lookup file set.
Processin g Stages
Copy – Filter – Funnel – Sort Remove duplicate – Aggregato r – Modify – Compress – Expand – Decode – Encode – Switch – Pivot stage – Lookup – Join – Merge – differenc e between look up, join and merge – change capture – Change apply – Compare – Differenc e – Surrogate key generator – Transform er.
Debug Stages
Head – Tail – Peek – Column generator – Row generator .
Real Time Stages
XML input – XML output
Local and Shared container s
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 performan ce analysis – Resource estimatio n – Slowly Changing Dimension s implement ation – Performan ce tuning.
Unit – 11 Job Sequencer s
Arrange job activitie s in Sequencer – Triggers in Sequencer – Restablit y – Recoverab ility – Notificat ion activity – Terminato r activity – Wait for file activity – Start Look activity – Execute Command activity – Nested Condition activity – Exception handling activity – User Variable activity – End Loop activity – Adding Checkpoin ts
Unit – 12 Informati on Analyzer
IBM WebShpere Informati on Analyzer overview – Data Profiling process – Column analysis – Primary key analysis – Foreign key analysis – Cross-domain analysis – Baseline analysis – Aanalysis result publicati on – Deleting statistic s reports – Baseline analysis reports – Cross-domain analysis summary statistic s 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 – Investiga te stage – Standardi ze stage Match Frequency stage – Unduplica te Match stage – Reference Match Stage – Survive stage.
Unit – 14 IBM Informati on Server Administr ation Guide
IBM WebSphere DataStage administr ation – Opening the IBM Informati on Server Web console – setting up a project ion the console – Customizi ng the project dashboard – Setting up security – 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 Informati on Server.