Datastage Training | IBM Datastage Training | Data Stage Training

Table of Contents

1. Data Warehouse Fundamentals
   1. Introduction to Data Warehouse
   2. Purpose of a Data Warehouse
   3. Architecture of a typical Data Warehouse
   4. OLTP vs OLAP
   5. Datawarehouse Lifecycle
   6. Data Marts vs Data Warehouses
2. Data Modeling
   1. Fundamentals of Data Modeling
   2. E-R Modeling
   3. Dimensions & Fact Tables
   4. Star Schema
   5. Snowflake Schema
3. ETL Design process
   1. Extraction, Transformation & Loading Overview
   2. ETL tools in the market
4. Datastage Introduction
   1. What is Datastage
   2. Datastage Server Architecture
   3. Datastage Server Components
   4. Datastage Client Components
5. Datastage Administrator
   1. Datastage project Administration
   2. Projects Management ( Add, Edit, Delete )
   3. Environment Management
   4. Runtime Column Propogation ( RCP )
   5. Parellel Jobs
   6. Checkpoints for Sequencer
   7. NLS Configuration
6. Datastage Director
   1. What is Datastage Director ?
   2. Datastage Jobs Validation
   3. Datastage Jobs Execution
   4. Job Monitoring
   5. Job Logs
   6. Job Scheduling
   7. Message Handlers
7. Datastage Designer
   1. What is Datastage Designer
   2. Why Parallelism ?
      1. Pipeline Parallelism
      2. Symmetric Multi Processing ( SMP )
      3. Massively Parallel processing ( MPP )
   3. partition Techniques
   4. Datastage Repository
   5. Passive & Active Stages
   6. Job Design Overview
   7. Designer Work Area
   8. Annotations
   9. Create, Delete Jobs
   10. Passing Parameters
   11. Job Compilation
8. Parallel Job Stages
   1. Database Stage
   2. File Stage
   3. Processing Stage
   4. Debug Stage
   5. Restructure Stage