
• 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
Course Rating
Ask any queries or doubts about this course & get responses from Teachers?