India-flagINDIA : +91-8099902123   usa-flagUSA : 201-710-8393
Happy New Year 2015 Call Me Back

training courses

DATASTAGE oNline training

  • Online Training : Available
  • Corporate Training : Available
  • DataStage Online Training
    STEP-1 DATA WAREHOUSE FUNDAMENTAL
    • 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

    If you want to know more about Datastage Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com