While loading lacks of data into target table, odi performance is degrading?

In this post, i have discussed on 

" load data from source(Oracle DB1) to target table(Oracle DB2) in same server

Source table have 45lacks of data. this data have to be load into target table.

I have create interface. i have taken LKM SQL to SQL & IKM SQL to SQL  incremental append knowledge modules i used.. after 24 hours, i have checked status in operator navigator. "its showing status like  loading"

still , interface is in loading status.some times odi is not responded. For this I used different knowledge modules.. "

To see solution for this, Go through this link.

https://community.oracle.com/thread/3828280