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

Are there any limitations for bex analyzer?

984


What is the difference between ods and info-cubes?

1021


What are tickets.

945


Why if one request fails, all the subsequent requests are turned to "red"?

1048


When to virtual providers based on dtp?

944


What are the general tuning guidelines?

2097


What are the load process and processing?

981


How would you do the archiving cubex.

950


What are the types of reports you can use in reporting agent?

2039


How do you check the alert monitor?

2154


What are the load process and post processing?

2015


How do you access to source system data in bi without extraction?

1005


what is the include program name?

2112


Explain return tables.

919


How can a cube have partitioned for which the data already exists?

927