Skip to Content
author's profile photo Former Member
Former Member

Aggregates

Hi Gurus

How could we delete data from E fact table? If we deactivate the aggregates then does the E Fact table gets deleted the data.

Regards,

Charan.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 20, 2011 at 06:15 AM

    Hi ....

    A cube has 2 fact tables - E and F. When the requests in the cube are not compressed the data exists in the F fact table and when the requests are compressed the data lies in the E fact table.

    Now, the compression can be done in two levels.........Aggregate level and Infocube level.......Only if you do the compression in the Infocube level then only data move from F fact table to the E fact table.....

    When the requests are compressed all the request ids are lost (set to NULL) and you would not be able to select/delete the data by request id. The data in the E fact table is compressed and occupies lesser space than F fact table....

    So, the fact is deletion of E fact table doesn't depend on Aggregates....To delete the data from the E fact table you have to delete the content of the cube......you can delete the records based on the requestid ........so either you have to go for a selective deletion ( If you know the selection criteris) otherwise delete the whole content of the cube.....

    Regards,

    Debjani....

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 20, 2011 at 06:04 AM

    Hi,

    Once you compress the cube then the data will move from F fact table to E fact table. Aggregates and E fact table is different, so if you delete the data from cube then the data will be deleted in Cube. Don't delete if it is Production System.

    Thanks

    Surendra

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.