BW cubes have mainly two fact tables -- F and E tables. The data is always loaded to the F fact table and the compression...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
process moves the data from the F to the E fact table.
If your F fact table becomes too big, your load process will considerably slow down depending on the volume. Also if the cube is compressed the query performance will improve due to various reasons. It is best to compress the cube every day, keeping only three or four days of non-compressed data.
Dig Deeper on Business intelligence software
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.