InfoSphere DataStage Performance Factors

It seems that the factors affecting Infosphere Datastage keep coming up, so, I thought it might be good to have an organized representation of what some of the major performance factors are and where they fit in the mix.

Infosphere Datastage Performance Factors

Infosphere Datastage Performance Factors

Load Strategy Zones

Source System

  • RDBMS
  • Indexes
  • Partitioning
  • Striping
  • Parallelism
  • Timestamps
  • Business rules
  • SQL Quality

Architecture

  • CPU’s
  • Memory
  • Drive Mappings & RAMDISK Use
  • Logical Nodes
  • Storage & Maintenance
  • Network I/O Latency

Infosphere and DataStage

  • Project Configuration
  • Nodes
  • Variable Configuration
  • Load Strategy
  • Job Design & Complexity
  • RDBMS Connection Type
  • SQL Quality
  • Licensing

Data Warehouse

  • RDBMS
  • Indexes
  • Partitioning
  • Striping
  • Parallelism
  • Timestamps
  • SQL Quality
  • Warehouse / Data Mart Pattern
  • Schema Structure

Related References

 

Advertisements

One thought on “InfoSphere DataStage Performance Factors

  1. Pingback: Infosphere DataStage – Node Best Practices | Scientia Compendium

Comments are closed.