Course Content

DATASTAGE COURSE CONTENT
IBM InfoSphere Data stage
Step-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
Step-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
Step-3 Process of ETL (Extraction, Transaction @Load)
 Introduction of Extraction , Transformation and Loding
 Types of ETL tools
 Key tools in the market
Step-4 Installation process
 Windows server
 Oracle
 .NET
 Datastage 7.5X2 & 8x&9x
Step-5 Difference
 Server jobs & Parallel jobs
Step-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
Step-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
Step-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
Step-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
Step-10 DS-Director
 About DS Director
 Validation
 Scheduling
 Status
 View logs
 Monitoring
 Suppress and Demote the Warnings
 Peek view
ANR(Datastage Trainer)
Step-11 DataStage Administrator
 Create Project
 Delete Project
 Protect Project
 Environmental variables
 Auto purge
 RCP
 OSH
 Commands Execute
 Multiple Instances
 Job Sequence Settings
Step-12 Job Sequence Area
 Job Activity
 Job sequencer
 Start loop Activity
 End loop Activity
 Notification Activity
 Terminator Activity
 Nested Condition Activity
 Exception handling Activity
 Execute Command Activity
 Wait for file Activity
 User variable Activity
 Adding Check Points
 Restartable
Step-13 Basic IBM InfoSphere Quality stage
 Data Quality
 Data Quality Stages
 Investigate Stage
 Standardize Stage
 Match Frequency Stage
 Reference Match Stage
 Unduplicated Match Stage
 Survive Stage

key service
 FAQS
 Covering DBA concepts
 Concentration on performance tuning
 Real time scenarios
 Certification guidance
 Resume preparation
 Sample resumes
 Interview & certification FAQS
 How to face the interview
 Class notes which is useful for who is trying for job