Datastage Online Training
Datastage Online Training Course Content :
Data Warehousing Concepts
Introduction to Data Warehousing
Ø What is Data Warehousing .Who needs Data Warehousing?
Ø Why Data Warehouse is required?
Ø Data Warehousing Architecture
Ø Types of Systems
Ø Data Warehousing Life Cycle
Data Modeling Concepts
Ø Integration Layer
Ø Staging Area
Ø Analysis & Reporting
Multi-Dimensional Modeling Concepts
Ø What is dimension modeling?
Ø Difference between ER modeling and dimension modeling
Ø What is a Dimension?
Ø What is a Fact?
Ø Start Schema
Ø Snow Flake Schema
Ø Difference between Star and snow flake schema
Ø Fact Table
Ø Different types of facts
Ø Dimensional Tables
Ø Fact less Fact Table
Ø Confirmed Dimensions
Ø Junk Dimensions
Ø Degenerative Dimensions
Ø What are slowly changing Dimensions?
Ø Different types of SCD’s
IBM DataStage Tool:
IBM DataStage Contents
Ø Introduction about Data Stage
Ø DataStage architecture
Ø Difference between Server Jobs and Parallel Jobs
Ø Difference between Pipeline Parallelism and Partition Parallelism
Ø Partition techniques
Ø Configuration File
Ø Difference between SMP/MPP Architecture
Ø Data stage components (Server components /Client components)
Administrator of Datastage Online Training
Ø Introduction about Administrator
Ø Project creation and project properties setup
Ø Introduction about Designer
Ø Type of Links
Ø Sequential file
Ø Dataset file
Ø File set
Ø Lookup file set
Ø Difference between Sequential file/Dataset/File set
Database Stages of Datastage Online Training
Ø Dynamic RDBMS
Ø Oracle Enterprise
Ø ODBC Enterprise
Ø Aggregate Stage
Ø Transformer Stage
Ø Surrogate Generator Stage
Ø Join Stage
Ø Merge Stage
Ø Lookup Stage
Ø Difference between Join/Lookup/Merge
Ø Difference between Join/Lookup
Ø Remove Duplicates
Ø Different types of sorting and sort stage.
Ø Different types of combining and collecting techniques.
Ø External filter
Ø Difference between filter, External filter and switch stages.
Ø Change Capture stage
Ø Job Parameters & Parameter set
Ø Run time column propagation
Ø Sequencer Jobs
Debugging Stage – Datastage Online Training
Ø Row Generator
Ø Column Generator
Data stage Director
Ø Introduction to Data stage Director
Ø Job Status View
Ø View logs
Note: Job design exercises based on Real time scenarios.