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.

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

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

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

Datastage project Administration - Editing projects and Adding Projects - Deleting projects Cleansing up project files - Enviranmental Variables-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.

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.

Introduction to Datastage Designer - Importance of Parallelism - Pipeline Parallelism - Partition Parallelism - Partitioning and collecting - Symmetric Multi Pro9cessing (SMP) Massively Parallel Processing (MPP) - Partition techniques - Datastage Repository Palette - Passive and Active stages - Job design overview - Designer work area - Annotations - Creating jobs - Importing flat file definitions - Managing the Metadata environment - Dataset management - Deletion of Dataset - Routines - Arguments.

Database Stages
Oracle - Teradata - ODBC - dynamic RDBMS

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 -Write RangeMap Stage.

XML input - XML output

ABAP Stage,IDoc Extract Stage,IDoc Load Stage, BAPI stage

Range Look process - Surrogate key generator stage - Slowly changing dimension stage - iway stage - FTP stage - Job performance analysis - Resource estimation - Slowly Changing Dimensions implementation - Performance tuning.

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

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.

About Data Quality - Datastage quality stages - Investigate stage - Standardize stage Match Frequency stage - Unduplicate Match stage - Reference Match Stage - Survive stage-MNS stage,WAVES stage - Migration of Datastage & Quality Stage Jobs from 7.5x2 to Version 8.1

IBM WebSphere DataStage administration - Opening the IBM Information Server Web console - setting up a project ion the console - Customizing 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 Information Server.

• Datastage Certification Guidence
• Performance Tunning of Parallel Jobs
• Datastage Installation process and setup
• Full Length Class Room Notes Which Covers all the concepts
• Well Versed Materials Which Covers Datawarehousing Basics, Datastage Concepts UnixCommands,Shall Scripts, Databases