Datastage

Home  >>  Datastage

Datastage Online Training

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

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

3.PROCESS OF ETL (EXTRACTION, TRANSACTION @LOAD)

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

4.INSTALLATION PROCESS

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

5.DIFFERENCE

  • Server jobs & Parallel jobs

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

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

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
    • Lookup
    • Join
    • Marge
    • Change Capture
    • Change Apply
    • Compare
    • Difference
    • Funnel
    • Remove Duplicate
    • Surrogate Key Generator
    • Pivot stage
    • Transformer

CONTAINERS

  • Shared Containers
  • Local Containers

10.DS-DIRECTOR

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

    11.DATASTAGE ADMINISTRATOR

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

    12.JOB SEQUENCE AREA

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

    13.IBM WEB SPHERE QUALITY STAGE

    • Data Quality
    • Data Quality Stages
    • Investigate Stage
    • Standardize Stage
    • Match Frequency Stage
    • Reference Match Stage
    • Unduplicated Match Stage
    • Survive Stage
    • Viewing audit details in operational DASHBOARD reports

Request Live Demo Invitation

Get notified on our Free Interactive Online Demo Session.

Please wait...

Check Reviews
Go to Contact Us

error: Content is protected !!