This content has been marked as final. Show 2 replies
1st you have to findout the step which is taking longer time.1 person found this helpful
Then check the query generated and do the performance tuning on it.
Check if you are using proper KM or not.
There is no ODI parameter that you can really tweak to increase overall performance (or else it would be enabled by default). So it really depends on your needs.
Most of the job is not done by ODI itself but by your underlying DB. ODI is an ELT and not an ETL.
So as Bhabani said, the best to do is to check the generated code and change your interface or your KM if needed.
For example if you think you need to run stats, you can do something like this : http://www.business-intelligence-quotient.com/?p=1754
You can also disable indexes before the integration steps and rebuild it afterwards.
Hope it helps.