Datastage Online Training

Datastage Online Training Course Content

Datastage Online Training

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
  • ODS
  • Data Marts
  • Types of Data Marts
  • Staging Area

Data Modelling Concepts

  • Data Modelling Types
  • Source
  • Integration Layer
  • Target

Multi-Dimensional Data Modelling Concepts

  • What is dimension data modelling?
  • Difference between ER modelling and dimension modelling
  • What is a Dimension?
  • Different Types of Dimension
  • Confirmed Dimensions
  • Junk Dimensions
  • Degenerate Dimensions
  • Slowly Changing Dimensions Types
  • What is a Fact ?
  • Fact Types ,Classification of Facts?
  • Fact less Fact Table
  • Different Schema Types
  • Star Schema
  • Snow Flake Schema
  • Difference between Star and snow flake schema

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 Client Components
  • Data stage Server Components

DataStage Administrator

  • Introduction about Administrator
  • Project creation and project properties setup

DataStage 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 Connector
  • 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
  • Sort
  • 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
  • Slowly Changing Dimension stage
  • Job Parameters & Parameter set
  • Run time column propagation
  • Sequencer Jobs

Debugging Stages

  • Head
  • Tail
  • Peak
  • Row Generator
  • Column Generator
  • Sample

Real Time Stages

  • XML Input
  • XML Output
  • XML

DataStage Director

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

Note:   Training based on real-time standards.

New Features :  XML stages will be covered as per current job opportunities.

 

HOMEWHY USOUR STRATEGY
PROJECT SUPPORTBLOGBECOME AN Instructor
CONTACT USWEB DESIGNINGOUR SERVICES
LEARNER SIGN UPTRAINER SIGN UPREFER A FRIENDSITEMAP
Copy rights © HyderabadSys.com