Datastage Online Training

                                                                                                         COURSE DURATION :  25 HOURS

Datastage online training course outline:

STEP-1 DATA WAREHOUSE FUNDAMENTALS

Datastage Online Training

  • 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
  • EnterpriseInformation 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)
  • OSHImporting 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

Fill up quick inquiry form to get more details on Datastage online training

Click here to register for the Datastage online training.

About our Datastage online training instructor:

 

  • Working in the Top MNC
  • Got 8+ years of experience
  • Trained more than 300+ candidates online
  • Working on BI and ETL tool
  • Expertise in exclusive DATASTAGE 8.7 Training
  • Hands on DATASTAGE online training