Best Online Training

Step-1: Data Warehouse Fundamentals

  • An Introduction of Data warehousing
  • purpose of Data warehouse
  • Data ware Architecture
  • OLTP Vs Data warehouse Applications
  • Data Marts
  • Data warehouse Lifecycle
  • SDLC

Step-2: Data Modeling

  • Introduction of Data Modeling
  • Entity Relationship Model
  • Dimensions and Fast Tables
  • Logical Modeling
  • Physical Modeling
  • Schemas Like Star Schema & Snowflake Schemas
  • Fact less Fact Tables

Step-3: Process of ETL (Extraction, Transaction @Load)

  • Introduction of Extraction , Transformation and Loading
  • Types of ETL tools
  • Key tools in the market

Step-4: Installation process

  • Windows server
  • Oracle
  • .NET
  • Data Stage 7.5X2 & 8x&9x

Step-5: Difference

  • Server jobs & Parallel jobs

Step-6: Components in Data Stage

  • Administrator client
  • Designer client
  • Director client
  • Import/export manager
  • Multi client manager
  • Console for IBM information server
  • Web console for IBM information server

Step-7: Introduction to IBM Web Sphere Data Stage and Quality Stage 8x

  • Data Stage Introduction
  • IBM Information server Architecture
  • IBM Data Quality Architecture
  • Enterprise Information Integration
  • Web Sphere Data Stage Components

Step-8: Data Stage Designer

  • About Web Sphere Data Stage Designer
  • Partitioning Methods
  • Partitioning Techniques
  • Designer Canvas
  • Central Storage
  • Job Designing
  • Creating the Jobs
  • Compiling and Run the Jobs
  • Exporting and importing the jobs
  • Parameter passing
  • System(SMP) & Cluster system(MPP)
  • Importing Method(Flat file, Txt, Xls and Database files)
  • OSH Importing Method
  • Configuration file

Step-9: Parallel Palette

Databases stages

  • Oracle Database
  • Dynamic RDBMS
  • ODBC
  • SQL Server
  • Teradata

File Stages

  • Sequential File
  • Dataset
  • Lookup File set

Testimonials

Very well organized and conceived. By following the course, I was able to learn and build on the concepts with minimal questions or frustration. It taught me what I was looking to learn, was well organized, and well-paced. I’m already applying what I learned at work.

Priyanka

The practical exercises were useful in offering ‘hands on’ experience. The interactive atmosphere and live examples used for illustration were refreshing.

VENKATESH

Course Reviews

4

22 ratings
  • 1 stars0
  • 2 stars0
  • 3 stars0
  • 4 stars0
  • 5 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 40 Days

Instructors

70 STUDENTS ENROLLED
    •   Live Instructor Led Course
    •   Batch Flexibility
    •   Customized Course
    •   Live Projects
    •   Resume Preparation

      Drop Us A Query

    Contact Training Adviser?



    Register

    Free Demo

    Or
    Call Us @

    9502434001

    ©2016 4bssolutions. All rights Reserved.DISCLAIMER.

    Show Buttons
    Share On Facebook
    Share On Twitter
    Share On Google Plus
    Share On Linkdin
    Share On Youtube
    Hide Buttons