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 the optional size of the aggregates?

Answer Posted / annobw

It should have around 10-20% of the size of fact table;

for ex: if fact table contains 1 million rows the aggregate
should have less than 200,000 rows

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to fetch the data from sap-r/3, sap-bw/bi to informatica system? what is step by step procedure? at what senario you retrieve the data from sap system to informatica or say dwh system? --

4954


What is an exception cell?

1793


What are the data target administration tasks?

2296


How would you do the calling a bw query from an abap program.

972


How do I send really complex mails from the workflow?

1000


What are the steps to create classes?

2143


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

2039


describe how you have used excel as a compliment to bex?

959


Explain web template?

947


What is transactional ODS object?

2500


Can you tell something about the multi-provider in the sap and how it is useful for the users?

950


what is high cardinality tell me brief

1505


What are the proposal options available?

2379


What is the procedure to create a data mart?

2034


Tell something you know about the dimension in the warehouse and how it can be optimized?

924