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
