India-flagINDIA : +91-8099902123   usa-flagUSA : 201-710-8393
Call Me Back

training courses

ibm datastage Online Training

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 Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com