Hi,
We are using ODI 11.1.1.6.0 and trying to insert 300 K records using IKM "IKM SQl Control Append" it is taking 13 hours to complete the load.
I am doing simple straight insert using IKM which has just 3 steps , 1.) Truncate Target Table 2.) Insert records 3.) Commit
However my interface uses 4 Temp interfaces (yellow interfaces) i had to use temp interfaces since i had around 10 tables to join and had to do some subselects.
Temp interfaces loads very fast with out any issues how ever in the main interface where i am joining temp interfaces it takes 13 hours to load 300 K records
My question is does using too many temp interfaces degrade the ODI load performance ? I tried to tune the query and reduce the cost of query but of no use.
Please suggest additional performance tuning steps that i can perform.
Thank you.