I am new to the BW, i am working on the Implementation project. Please let me know when F and E Fact tables come into the picture and is there any difference b/w these two.
Thanks and Regards
The F fact table is write optimized while the E fact table is read optimized. When you compress requests in a cube the E fact table comes into effect. Data is stored in partitions based on the defined values...this is normally based on one of the available time characteristics such as calmonth or calyear. In the case of F fact table the partitions are based on request IDs. E fact table data cannot be deleted based on requests as the request ID is dropped while compression.