• Data Warehousing Concepts                                                                                              
• Data Warehouse & Data Warehousing
• Data Warehousing Architecture
• ETL Project Phases
• ETL Process
• ETL Architecture
• Over view of Project Architecture
• Data Modeling
• Data Warehousing Teams and Roles
• Understand Mapping Document
• Datastage Introduction                                                          
• History and Features
• Difference between 7.5X2 & 8.x
• IBM DS 8.0.1
• DS InfoSphere 8.5 Enhancements
• IBM DataStage 7.5X2 $ 8.x Architecture
• Partition & Pipeline Parallelism
• Partitioning & Re- Partitioning Techniques
• Configuration File & Node Components
• IBM Web Sphere DS & QS                                                                   
• 7.5X2 & 8.x Enhancements – New Features
• Parallel Processing Environments (SMP,MPP etc.,)
• DS Client Components Overview
• DS Architecture Components Overview
• Datastage Designer                                                                   
• DS Job Design Process
• Compile, Force Compile and Multiple Job Compile
• Import & Export of Repository Components
• Node Configuration

• Datastage Director                                                                                                        
• Schedule / Run / Validate a Compiled Job
• Message Handling
• Monitor Jobs, Filter / Purge Logs
• Unlocking Job & Customize
• Datastage Jobs & Stages                                                                                             
• Difference between Server & Parallel jobs
• Overview of Parallel Jobs, Server Jobs, Mainframe Jobs, Migration Jobs and Job Sequencing Jobs
• Repository, DS Designer Toolbar & Palette
• Active and Passive Stages
• Palette Customization
• Working with File Stages                                                                                              
• Sequential File Stage
• Data Set and Types
• File Set
• Differences -  Data Set , File Set, Sequential File Stages
• Lookup File Set Stage
• Development & Debug Stages
• Row Generator and Column Generator Stage
• Head, Tail and Sample Stages
• Peek Stage
• Copy Stage
• Working with Relational Databases                                                                            
• Enterprise and Plug-in Stages Overview
• Oracle, DB2, SQL Server Stages
• ODBC

Dynamic RDBMS Stage

Processing Stages

• Horizontal Combining                                                                                        
• Join Stage
• Lookup Stage (Normal, Sparse, Range, Case less)
• Merge Stage
• Differences between Lookup, Join & Merge
• Funnel Stage
• Sorting and Vertical Combining                                                                                  
• In-stage sorts
• Sort Stage
• Aggregator Stage
• Remove Duplicates Stage
• Data Transformation with Transformer                                                                     
• Basic Transformer
• Parallel Transformer
• External Functions
• Stage Variables and System Variables
• Transformer Constraints
• Transformer Execution Order
• External Before / After Routines
• Filtering Methods                                                                                                          
• Constraints & Source Level
• Filter Stage
• Switch Stage
• External Filter Stage
• Remaining Stages                                                                                                         
• Modify Stage
• Compress & Expand Stage
• Decode & Encode Stage
• Generic Stage
• Pivot Stage
• Slowly Changing Dimensions                                                                                    
• Type – 0, 1, 2, 3, 4 & 6 Dimensions
• Implementing SCD – I & II
• SCD Stage
• Change Capture & Change Apply Stage
• Difference & Compare Stage
• Surrogate Key Stage
• Restructure & Real Time Stages                                                                                 
• Column Export, Column Import Stages
• XML Input & XML Our Put Stage
• Performance Tuning Techniques                                                                                
• Performance Tuning with best practices
• Performance Tuning with Partitioning Techniques
• Job Score
• Performance Analysis & Estimate resource
• Advanced Topics                                                                                                           
• Parameter Set
• Job Control        
• Job Sequencing
• Batch Jobs