IBM DATASTAGE ONLINE TRAINING
ENROLL NOW

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

  • 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

  • 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.
  • SCD stage
  • Adding job parameters to a job
  • Parameter set
  • Run time column propagation

 

DEBUGGING STAGE

  • Head
  • Tail
  • Pea
  • Row Generator
  • Column Generator
  • Sample

 

DATA STAGE DIRECTOR

  • Introduction to Data stage Director
  • Job Status View
  • View logs
  • Scheduling

 

If you want to know more about IBM DATASTAGE ONLINE TRAINING do not hesitate to call +91-7774892805 or mail us on contact@intelogik.com

ENROLL NOW