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

Ø OLTP

Ø OLAP

Ø Data Warehousing Life Cycle

Data Modeling Concepts

Ø Source

Ø Integration Layer

Ø Staging Area

Ø Target

Ø Analysis & Reporting

Ø ODS

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

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

Database Stages of Datastage Online Training

Ø Dynamic RDBMS

Ø Oracle Enterprise

Ø ODBC Enterprise

Processing Stages

Ø Aggregate Stage

Ø Transformer Stage

Ø Surrogate Generator Stage

Ø Join Stage

Ø Merge Stage

Ø Lookup Stage

Ø Difference between Join/Lookup/Merge

Ø Difference between Join/Lookup

Ø Remove Duplicates

Ø Switch

Ø Pivot

Ø Modify

Ø Funnel

Ø 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.

Ø Change Capture stage

Ø Job Parameters & Parameter set

Ø Run time column propagation

Ø Sequencer Jobs

Debugging Stage – Datastage Online Training

Ø Head

Ø Tail

Ø Peak

Ø Row Generator

Ø Column Generator

Ø Sample

Data stage Director

Ø Introduction to Data stage Director

Ø Job Status View

Ø View logs

Ø Scheduling

Note: Job design exercises based on Real time scenarios.

More about

data stage training Online