DTP step taking longer time
As Iam new to SDN I tried to find an answer to this issue. Please find below is the Issue
There is a process chain. In this PC, After deleting the Index step, there is a DTP step, which updates the Cube with one DSO; the first DTP step is much delayed for update to cube. But where as the immediate DTP step to the same cube with another DSO is finishing so faster.
The prob is with the first DTP step which updates the cube frm DSO In this there is one Job with the namingconvention shown as BIDTPR_545787_1 was running more than 10000sec to update the Cube. Dont know why this job is running beyond so much time, where as it usually prior to some days back completes within 3000 secs.
Now the prob. is that the Data loading performance of the Prod system effected, where this DTP step is ruuning beyond time. Please can someone suggest how to find and resolve this issue as not sure why the below kind of JOBS are running for more time causing the PC much delayed for completion
BIDTPR_545689_1 etc of the First DTP are running longer. Pls help!