- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
ODI performance issue.
this is my execution of mapping in DEVELOPMENT env.
The same mapping when executed in Testing Env takes '27' minutes.
1)all indexes are fine for tables being used in both environments.
2)The higher environment has more processors so should take less time than DEV.
3)no. of inserts only differ by 20K records.
4) ORACLE DB THROUGHOUT
5)TABLE TO TABLE
How would one approach this problem?