
Data Warehousing Concepts
ETL Concepts
Introduction to DataStage
o Product Variants
o Architecture
o Server & Client components
Introduction to DataStage client
o Designer
o Director
o Manager
o Administrator
o Information Server
My First DataStage job
o Palette
o Repository
o Develop
o Compile
o Run
Introduction to DataStage Stages
o Sequential file
o Dataset
o Transformer
o Links
o Variables
o Reading, Writing to DB Tables
o Column Definitions
o Lookup
o Join
o Merge
o Modify
DataStage Functions
o Date Time
o Logical
o Mathematical
o Null Handling
o String
o Type Conversion
DataStage Sequences
o Job Activity
o Sequencer
o Exception Handler
o Notification Activity
o Wait for File
o Terminator
Debugging
o Debugger Interface
o Peek / Sample/ Head / Tail
Deployment
o Creating packages in Server Manager
o Import, Export of dsx file
Scheduling jobs
o Job Logs
o Job monitoring
Comming soon..
Course Rating
Ask any queries or doubts about this course & get responses from Teachers?