Datastage - Data WareHouse Course

Introduction to Data Warehousing

• What is Data Warehousing?

• Who needs Data Warehousing?

• Why Data Warehouse is required?

• Types of Systems

• OLTP

• OLAP

• Maintenance of Data Warehouse

• Data Warehousing Life Cycle

Database Design and Data Modeling

• Source

• Integration Layer

• Staging Area

• Target

• Analysis & Reporting

• ODS

Multi-Dimensional Modeling

• 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

• Unconfirmed Dimensions

• Junk Dimensions

• Monster Dimensions

• Degenerative Dimensions

• What are slowly changing Dimensions?

IBM WebSphere DataStage and Quality Stage, Versions 8.0.1Contents

• Introduction about Data Stage

• Difference between Data Stage 7.5.2 and 8.0.1

• What is way ahead in Data Stage?

• IBM Information Server 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

• Configuration File

• Difference between SMP/PMP(Cluster) Architecture

• Data stage components (Server components /Client components)

Designer

• Introduction about Designer

• Repository

• Palette

• Type of Links

• File Stages

• Sequential file

• Dataset file

• File set

• Lookup file set

• Difference between Sequential file/Dataset/File set

• Overview of iWay, Classic federation and netezza

• Database Stages

• Dynamic RDBMS

• Oracle Enterprise

• ODBC Enterprise

• Stored Procedure

Processing Stages

• Change Capture

• Compare Stage

• Difference Stage

• Aggregate Stage

• Transformer Stage

• Difference between basic transformer and transformer

• Surrogate Generator Stage

• Join Stage

• Merge Stage

• Lookup Stage

• Difference between Join/Lookup/Merge

• Difference between Join/Lookup

• Remove Duplicates

• Switch

• Pivot

• Modify

• Funnel

• Generic stage

• Different types of sorting and sort stage.

• Different types of combining and collecting techniques.

• Filter

• External filter

• Difference between filter, External filter and switch stages.

• SCD stage

• Encode and decode stages

• FTP stage

• Adding job parameters to a job

• Parameter set

• Difference between partitioning and re partitioning

• Run time column propagation

• Schema files

Debugging Stage

• Head

• Tail

• Pea

• Row Generator

• Column Generator

• Sample

Data stage Director

• Introduction to Data stage Director

• Job Status View

• View logs

• Scheduling

• Batches Creation

• Cleaning resources using Administrator