DSO to Cube loading is very slow
I have one DSO which has more than 16 million entries and it took around 1 hour to load from PSA.
However when I am trying to load it to Cube from DSO it taking very long to finish.
I am loading fiscal year wise but then also for 2 million entries its taking very long time and not finishing.
Is there any solution for this?
This is first time this cube is getting loaded.
index has been dropped before loading.
there is no routine in the transformation.
Could anyone suggest something here?