IBM Datastage

IBM Datastage

Why IBM Datastage Online Training Only with Virtuous trainers?

Virtuous Trainers offers IBM DATSTAGE Online and Corporate trainings that are tailor made as per the requirements of an entity or an individual. With industry's best trainers anyone who joins our institute will be assured of 100% quality training with real time scenarios and live projects(most technologies) and assignments. Apart from the course content of the respective technologies our curriculum includes resume building, interview tips, global certification guidance and many more facilities which help an individual prepare to further their careers.

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

To Enroll for a free demo kindly Contact
Mobile : +91 8790035436
EMail ID : enquiry@virtuoustrainers.com
Skype ID : virtuoustrainers