Course Duration 30 Hours

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

STEP-5 DIFFERENCE

  • Server jobs & Parallel jobs

STEP-6 COMPONENTS IN DATASTAGE

  • 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 DATASTAGE 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 DATASTAGE 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

 

DEV/DEBUG STAGES
  • Peek
  • Head
  • Tail
  • Row generator
  • Column generator
PROCESSING STAGES
  • Slowly changing dimension stage
  • Slowly changing dimensions implementation
  • Aggregator
  • Copy
  • Compress
  • Expand
  • Filter
  • Modify
  • Sort
  • Switch
  • Look up
  • Join
  • Merge
  • Change capture
  • Change apply
  • Compare
  • Difference
  • Funnel
  • Remove duplicate
  • Surrogate Key Generator
  • Pivot stage
  • Transformer
CONTANERS
  • Shared Containers
  • Local Containers

STEP-10 DS-DIRECTOR

  • About DS Director
  • validation
  • Scheduling
  • Status
  • View logs
  • Monitoring
  • Suppress and Demote the Warnings
  • Peek view

STEP-11 DATASTAGE ADMINISTRATOR

  • Create Project
  • Delete Project
  • Protect Project
  • Environmental variables
  • Auto purge
  • RCP
  • OCH
  • Commands Excute
  • Multiple Instances
  • Job Sequence Settings

STEP-12 JOB SEQUENCE AREA

  • Job Activity
  • Job sequencer
  • Start loop Activity
  • End loop Activity
  • Notification Activity
  • Terminatior Activity
  • Nested Condition Activity
  • Exception handling Activity
  • Wait for file Activity
  • User variable Activity
  • Adding Check Activity
  • Restart able

Demo Recording:-


Free Demo Class

Register Now