Unit-1 Data Warehouse Fundamentals

 An Introduction of Data warehousing
 purpose of Data warehouse
 Data ware Architecture
 OLTP Vs Data warehouse Applications
 Data Marts
 Data warehouse Lifecycle
 SDLC

Unit-2 Data Modeling

 Introduction of Data Modeling
 Entity Relationship Model
 Dimensions and Fast Tables
 Logical Modeling
 Physical Modeling
 Schemas Like Star Schema & Snowflake Schemas
 Fact less Fact Tables

Unit-3 Process of ETL (Extraction, Transaction @Load)

 Introduction of Extraction , Transformation and Loding
 Types of ETL tools
 Key tools in the market

Unit-4 Installation process

 Windows server
 Oracle
 .NET
 Datastage 7.5X2 ,8x,9x and 11x

Unit-5 Difference

 Server jobs & Parallel jobs

Unit-6 Components in Datastage

 Administrator client
 Designer client
 Director client
 Import/export manager
 Multi client manager
 Console for IBM imformation server
 Web console for IBM imformation server

Unit-7 Introduction to IBM infoSphere Datastage and Quality Stage

 Datastage Introduction
 IBM Information server Architecture
 IBM Data Quality Architecture
 Enterprise Information Integration
 Web Sphere DataStage Components

Unit-8 DataStage Designer

 About Web Sphere DataStage Designer
 Partitioning Methods
 Partitioning Techniques
 Designer Canvas
 Central Storage
 Job Designing
 Creating the Jobs
 Compiling and Run the Jobs
 Exporting and importing the jobs
 Parameter passing
 System(SMP) & Cluster system(MPP)
 Importing Method(Flat file, Txt, Xls and Database files)
 OSH Importing Method
 Configuration file

Unit-9 Parallel Palette

Databases stages
 Oracle Database
 Dynamic RDBMS
 ODBC
 SQL Server
 Teradata
File Stages
 Sequential File
 Dataset
 Lookup File set
Dev/Debug Stages
 Peek
 Head
 Tail
 Row Generator
 Column Generator
Processing Stages
 Slowly changing dimension stage
 Slowly changing dimensions implementation
 Aggregator
 Copy
 Compress
 Expand
 Filter
 Modify
 Sort
 Switch
 Lookup
 Join
 Marge
 Change Capture
 Change Apply
 Compare
 Difference
 Funnel
 Remove Duplicate
 Surrogate Key Generator
 Pivot stage
 Transformer
Containers
Shared Containers
Local Containers

Unit-10 DS-Director

 About DS Director
 Validation
 Scheduling
 Status
 View logs
 Monitoring
 Suppress and Demote the Warnings
 Peek view

Unit-11 DataStage Administrator

 Create Project
 Delete Project
 Protect Project
 Environmental variables
 Auto purge
 RCP
 OSH
 Commands Execute
 Multiple Instances
 Job Sequence Settings

Unit-12 Job Sequence Area

 Job Activity
 Job sequencer
 Start loop Activity
 End loop Activity
 Notification Activity
 Terminator Activity
 Nested Condition Activity
 Wait for file Activity
 Restartable

Unit-13 Overview IBM InfoSphere Quality stage

 Data Quality
 Data Quality Stages
 Investigate Stage
 Standardize Stage
 Match Frequency Stage
 Reference Match Stage
 Unduplicated Match Stage
 Survive Stage
ANR key service