DataStage Course Content

                             DataStage 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 Loding
    Types of ETL tools
    Key tools in the market

STEP-4 INSTALLATION PROCESS

    Windows server
    Oracle
    .NET
    Datastage 7.5X2 & 8x

STEP-5 DIFFERENCE

    Server jobs & Parallel jobs

STEP-6 COMPONENTS IN DATASTAGE

    Administrator clint
    Designer client
    Director client
    Import/export manager
    Multi client manager
    Console for IBM imformation server
    Web console for IBM imformation server

STEP-7 INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X

    Datastage Introduction
    IBM Information server Architecture
    IBM Data Quality Architecture
    Enterprise Information Integration
    Web Sphere DataStage Components

STEP-8 DATASTAGE DESIGNER

    About Web Sphere DataStage 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

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
    OSH
    Commands Execute
    Multiple Instances
    Job Sequence Settings

STEP-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
    Restartable

STEP-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

KEY SERVICE

    FAQS
    Covering DBA concepts
    Concentration on performance tuning
    Real time scenarios
    Certification guidance
    Resume preparation
    Sample resumes
    Interview & certification FAQS
    How to face the interview
    Class notes which is useful for who is trying for job
    Project preparation