Call Us at: +1616-469-0394 | Email: info@hexissoft.com

Follow Us on: facebook_icon twitter-icon linkdein_icon

COURSES

QUICK ENQUIRY











aboutus_banner

Datastage Online Training

Data Stage

Introduction  

  • Introduction about Data Stage
  • Difference between Server Jobs and Parallel Jobs
  • Difference between Pipeline Parallelisms
  • Partition techniques (Round Robin, Random, Hash, Entire,

Same,Modules,Range,DB2,Auto)

  • Configuration File
  • Difference between SMP/MPD architecture
  • Data Stage Components (Server components/Client Components)
  • Package Installer

Data Stage Administrator

  • Creating project, Editing project and Deleting project
  • Permissions to user
  • Apt Config file
  • Environment variable creation, permission

Data stage director

  • Introduction to Data stage Director
  • Job status View
  • View logs
  • Scheduling
  • Batches Creation

PROCESS OF ETL (EXTRACTION, TRANSACTION @LOAD)

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

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

ADS-DIRECTOR

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

 

Back to Top…