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
Oracle – Teradata – ODBC – dynamic RDBMS – DB2
Sequential file – Dataset – File set – Lookup file set.
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.
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.
Datastage training provided to below location trainees :
Datastage online course india,Datastage training, Datastage training Atlanta, Datastage training Austin, Datastage training Baltimore, Datastage training Bay Area, Datastage training Boston, Datastage training course, Datastage training Denver, Datastage training Detroit, Datastage training Houston, Datastage training in chicago, Datastage training in dallas, Datastage training in michigan, Datastage training in new york, Datastage training in nj, Datastage training in texas, Datastage training in usa, Datastage training in virginia, Datastage training Indianapolis, Datastage training Los Angeles, Datastage training Maryland, Datastage training Minneapolis, Datastage training Oakland, Datastage training Orlando, Datastage training Philadelphia, Datastage training Phoenix, Datastage training Pittsburgh, Datastage training Portland, Datastage training Sacramento, Datastage training San Diego, Datastage training San Francisco, Datastage training St Louis, Datastage training Washington,Datastage training uk,Datastage training singapore,Datastage training qatar,Datastage training australia,Datastage training newzealand,Datastage training south africa,Datastage training melbourne,Datastage training london,Datastage training canada,Datastage training dubai,Datastage training delhi,Datastage training china,Datastage training japan,Datastage training malasia,Datastage training michigan,Datastage training and free demo