Forum Stats

  • 3,827,801 Users
  • 2,260,822 Discussions
  • 7,897,379 Comments

Discussions

ODI performance issue.

User_Q4ESY
User_Q4ESY Member Posts: 1 Green Ribbon
edited May 10, 2022 2:08PM in Data Integrator

this is my execution of mapping in DEVELOPMENT env.

The same mapping when executed in Testing Env takes '27' minutes.

Extra Info:-

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?

Answers