Visit Datastage notes for self study
DataStage 9.1 Online Training
Course Duration : 40 Hours
Introduction to Data Warehousing
What is Data Warehousing?
Who needs Data Warehousing?
Why Data Warehouse is required?
Types of Systems
Maintenance of Data Warehouse
SDLC – Data Warehousing Life Cycle
Database Design and Data Modeling
Analysis & Reporting
What is Extract Transform Load
Introduction of Extraction, Transformation and Loading
Types of ETL tools
Key tools in the market
What is dimension modeling?
Difference between ER modeling and dimension modeling
What is a Dimension?
What is a Fact?
Snow Flake Schema
Difference between Star and snow flake schema
Different types of facts
Fact less Fact Table
What are slowly changing Dimensions?
Different types of SCD’s
IBM WebSphere DataStage and QualityStage, Versions 9.1 Contents
Introduction about Data Stage
Difference between Data Stage 7.5.2 and 9.1
What’s new in Data Stage 9.1?
What is way ahead in Data Stage?
IBM Information Sever architecture
Datastage within the IBM Information Server architecture
Difference between Server Jobs and Parallel Jobs
Difference between Pipeline Parallelism and Partition Parallelism
Partition techniques (Round Robin, Random,
Hash, Entire, Same, Modules, Range, DB2, Auto
Difference between SMP/PMP(Cluster) Architecture
Data stage components (Server components /Client components)
Introduction about Designer
Type of Links
Lookup file set
Difference between Sequential file/Dataset/File set
Overview of iWay, Classic federation and netezza
Difference between basic transformer and transformer
Surrogate Generator Stage
Difference between Join/Lookup/Merge
Difference between Join/Lookup
Different types of sorting and sort stage.
Different types of combining and collecting techniques.
Difference between filter, External filter and switch stages.
Encode and decode stages
Adding job parameters to a job
Difference between partitioning and re partitioning
Run time column propagation
Data stage Director
Introduction to Data stage Director
Job Status View
Cleaning resources using Administrator