DTP load is too slow after converting the DSO Type

Hi Guys,

I have converted standard DSO to Write Optimized but after converting to "WO" DSO the DTP is taking long time say 7 hours to complete...but mainly getting stuck in the "End Routine " Transformation End. There are lot of lookups written in the end routine.

So again converted Write Optmized DSO to "Standard" but still the DTP load is taking 6-10 hrs to complete, not able to understand the routcause of the issue.

Could you pls if somebody has experience this issue kindly let me know.

Regards,

Antony