Tuesday, May 26, 2015

Performance Tuning

Performance Tuning

The following things will increase performance at ODI level

  • Select Appropriate Knowledge module to Load data
  • Execution of Joins and Filter in appropriate area (i.e., Source/Stage/Target)
  • Increase Array Fetch size and Batch Fetch size of the data server
  • select different schema for data and work in "Physical architecture" 
  • Enable Archival Logging
  • Truncate mode no for temporary tables
  • CDC log based improves performance


No comments:

Post a Comment