Skip to Content
Former Member
Sep 03, 2008 at 09:01 PM

need to decide to keep data in DSO or not


Hi all,

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.