Scripting School Provides Ant Online Training , AngularJS Online Training, Backbone js Online Training , Node.Js Online Training , JavaScript Online Training, LUA Online Training, Groovy Scripts Online Training , Groovy on Grails Online Training , HTML5 Online Training , Maven Online Training , Perl Script Online Training , PowerShell Online Training , Python Online Training , PHP Online Training , Ruby Script Online Training , Ruby on Rails Online Training , R Scripts Online Training , TCL Script Online Training , Unix Shell Script Online Training , VBScript Online Training ,Hadoop Online Training, Advanced Java Online Training, Core Java Online Training, Hibernate Online Training, J2EE Online Training, Spring Online Training, .NET Online Training, Microsoft BI Online Training, Microsoft SSAS Online Training, Microsoft SSIS Online Training, Microsoft SSRS Online Training, SharePoint BI Online Training, SharePoint Online Training, Windows Server 2008 Admin Online Training, Cognos Online Training, Datastage Online Training, Informatica Online Training, OBIA Online Training, OBIEE Online Training, Teradata Online Training, Advanced Perl Online Training, Android Online Training, Drupal Online Training, Joomla Online Training, PHP Online Training, Python Online Training, Salesforce Online Training, SAS Clinical Online Training, SEO Online Training, Veritas Volume Manager Online Training, Web Designing Online Training.

Data Warehousing Concepts:
Introduction to Data Warehousing

  • What is Data Warehousing?
  • Who needs Data Warehousing?
  • Why Data Warehouse is required?
  • Types of Systems
  • OLTP
  • OLAP
  • Maintenance of Data Warehouse
  • Data Warehousing Life Cycle

Database Design and Data Modeling

  • Source
  • Integration Layer
  • Staging Area
  • Target
  • Analysis & Reporting
  • ODS

Multi-Dimensional Modeling

  • 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
  • Unconfirmed Dimensions
  • Junk Dimensions
  • Monster Dimensions
  • Degenerative Dimensions
  • What are slowly changing Dimensions?
  • Different types of SCD’s

IBM WebSphere DataStage and Quality Stage, Versions 8.0.1Contents

  • Introduction about Data Stage
  • Difference between Data Stage 7.5.2 and 8.0.1
  • What’s new in Data Stage 8.0.1?
  • What is way ahead in Data Stage?
  • IBM Information Server architecture
  • Datastage within the IBM Information Server architecture
  • Difference between Server Jobs and Parallel Jobs
  • Difference between Pipeline Parallelism and Partition Parallelism
  • Partition techniques (Round Robin, Random,

Hash, Entire, Same, Modules, Range, DB2, Auto

  • Configuration File
  • Difference between SMP/PMP(Cluster) Architecture
  • Data stage components (Server components /Client components)


  • 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
  • Overview of iWay, Classic federation and netezza
  • Database Stages
  • Dynamic RDBMS
  • Oracle Enterprise
  • ODBC Enterprise
  • Stored Procedure

Processing Stages

  • Change Capture
  • Compare Stage
  • Difference Stage
  • Aggregate Stage
  • Transformer Stage
  • Difference between basic transformer and transformer
  • Surrogate Generator Stage
  • Join Stage
  • Merge Stage
  • Lookup Stage
  • Difference between Join/Lookup/Merge
  • Difference between Join/Lookup
  • Remove Duplicates
  • Switch
  • Pivot
  • Modify
  • Funnel
  • Generic stage
  • 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
  • Encode and decode stages
  • FTP stage
  • Adding job parameters to a job
  • Parameter set
  • Difference between partitioning and re partitioning
  • Run time column propagation
  • Schema files

Debugging Stage

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

Data stage Director

  • Introduction to Data stage Director
  • Job Status View
  • View logs
  • Scheduling
  • Batches Creation
  • Cleaning resources using Administrator
Datastage Online Training institute in Hyderabad