can anyone say me the full form of E-fact tables.
F-fact means fact table. in same way what is mean by E-fact table
The info cube contains two fact tables - E and F and both the structures are same.
The "F Table" or "Fact Table" is the main table of the InfoCube. It will contain the values for the Key Figures and references (Foreign Keys) to the dimensions of the InfoCube. When load data into the InfoCube, this data will go to the Fact Table.
The "E Table" or "E-Fact Table" will contain only the loaded data that has already been compressed. When you compress requests from the InfoCube, the data will be transferred from the F Table to the E Table. The information will be the same, and there should be no difference between a query run over data from the E Table or from the F Table (before compressing).
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.
When you load a data target, say a cube, the data is stored in the F fact table. If the cube is compressed, the data in the F fact table is transferred to the E fact table.
Sign up for STechies
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.