I have couple of questions reg data loads.
1. I am facing problems with open items load from DSO to Cube. Recently we have deleted few months data from DSO using selective deletion after that the loading from DSO to Cube taking long time (3 hrs for 50, 000 records).
Before deleting it used to take only 30 mins for the same data. Can any one please advise me what could be the reason for this.
2. We have another load from DSO to Cube (CRM - service orders) as a full load. So we are deleting data each time we load to cube (weekly) which is taking 10 hrs. The DSO is a daily load from CRM as a delta. I was told by my colleague that they couldn't do deltas to cube as records may change in CRM resulting in a duplicate record in cube (for ex with diff status like active and liable).
Can any one please send me docs reg delta loads as I am not sure about how delta works. And also any ideas what we can do to improve performance.
My mail id email@example.com