+91-80999 02123201-710-8393

IBM Data Stage 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

Note: Job designing exercises based on Real time scenarios.

 

Address

#3-5-839/6, 104, 1st Floor, LR Plaza, Beside Bharat Petrol Pump, Hyderguda,
Hyderabad - 500 029

Phone     : 040- 6464 5154
Email      : info@careeronlinetrainings.com
Website : www.careeronlinetrainings.com

Skype ID : careeronlinetrainings

Testimonials

The course content was appropriate and useful. The online trainers were competent and useful. The best thing about the course was the young learner and learning Vs acquisition section.

The thing that the course needs improvement is the format of the assignment

Keerthi
Hyderabad.

I am Mushtak Shaik from Hyderabad. The course content was appropriate and useful. The online trainers were competent and useful.

The thing that the course needs improvement is the format of the assignment


Mushtak Shaik
Hyderabad.