Could someone please help me with the following scenario.
We have some data that is being loaded to DSO from there into 2 cubes. One cube will hold very detailed data (just like in DSO, which was created for faster reporting), Another Cube holds abstract level details.
we were thinking to delete data from DSO selectively as and when we upload the data to details cube, to eliminate redundancy and to save hardware resources.
So, could someone help me, what is the best practice for deleting the data from DSO. Or if you think it should not be done, then explain why its not.
any inputs will be greatly appreciated with points.