Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 is structure in reporting?

1490


If you are asked to change the way tables are displayed in web reporting how would you do this?

1836


What is extended star schema?

982


What is the use of the info area in the sap bw system?

956


How do you activate personalization for bex?

2623


What is the other flags?

2152


What is CO-PA retraction?

2133


How will you add buttons to a template?

2003


What is occurence

2211


What is compression in the data warehouse?

1064


please tell me the most frequently asked interview questions about sap BW with answers

4981


Are there any limitations for bex analyzer?

1012


list the steps to do the extractig data from r/3.

900


what are the extractions made in a sap bw project using lo cockpit extraction in mm and sd and fi?what is the requirement and name them?

4537


what are the drawbacks of ods?

1065