1.

List Some Factors For Performance Tuning In Data Services?

Answer»

The following SECTIONS describe ways you can adjust Data Integrator performance

  •  Source-based performance options
  •  Using ARRAY fetch size
  •  Caching data
  •  Join ordering
  •  Minimizing extracted data
  •  Target-based performance options
  •  Loading method and rows per COMMIT
  •  Staging tables to speed up auto-correct loads
  •  JOB design performance options
  •  Improving throughput
  •  Maximizing the number of pushed-down operations
  •  Minimizing data type conversion
  •  Minimizing local conversion
  •  Improving Informix repository performance

The following sections describe ways you can adjust Data Integrator performance


Discussion

No Comment Found

Related InterviewSolutions