Hello All,
I'm facing an issue related to production environment. I've created a package in DEV environment which does a lot of tasks. The execution of this package takes around 20 seconds to finish, however, when I deploy it on production environment, it takes around 20 MINUTES.
Considering that I don't have any data in production yet (to be honest, I have only 10 rows in production) and in development, I have more than 5k rows I don't see any reason to take this time.
Checking logs from production, I've noticed that some tasks are taking more time than the sum of sub-tasks, for example, in picture below, the step 12 took 19 seconds, but the sum of the sub-tasks is round 4 seconds.
I don't have experience in ODI tunning and this situation is very weird for me. I don't know where to start checking considering this scenario.
Do you guys have any idea how can I check to improve this time?
I really appreciate some help.
Thanks.