What is compression or collapse?

Answer Posted / sapbhai

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 F fact table (uncompressed fact table) is moved to E fact table (compressed fact table). Compressed data occupies less space in many cases and thus a performance boost.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the system tools you can use?

1712


What are the SAP enhancements to enhance HR data?

1711


What are the general restrictions?

1601


What is Infoset Query?

681


What is the importance of 0requid?

699






How we do the sd and mm configuration for bw?

645


What is the table filled when you select ABAP?

1745


What is a content extraction?

1787


What is infoobject catalog?

649


What are the Oracle specific tuning should be done?

1404


What is a control query?

1691


What are the different type of infoset joins?

586


What are the tools to monitor overall query performance.

565


What is extended star schema?

628


What is update mode for master data?

1742