Follow Us:

Datastage Training in Chennai


Course Duration

40 HOURS Sign in with Facebook Sign in with Facebook

Course Contents

Datastage
    STEP-1 DATA WAREHOUSE FUNDAMENTALS
  • An Introduction of Data warehousing
  • Data ware Architecture
  • Data warehouse Lifecycle
  • STEP-2 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-3 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-4 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-5 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-6 DS-DIRECTOR
  • About DS Director
  • Validation
  • Scheduling
  • Status
  • View logs
  • Monitoring
  • Suppress and Demote the Warnings
  • Peek view
  • STEP-7 DATASTAGE ADMINISTRATOR
  • Create Project
  • Delete Project
  • Protect Project
  • Environmental variables
  • Auto purge
  • RCP
  • OSH
  • Commands Execute
  • Multiple Instances
  • Job Sequence Settings
  • STEP-8 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-9 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 report
Register Now

You will Learn How To :

Course Benefits :

Register Now

Please use the form below to make your career excellent.