Interested to Buy Any Domain ? << Click Here >> for more details...
why u go for aggregate? tell me one example?
- 5 Answers
- 17648 Views
- Accenture, HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / govardhan
INSTEAD OF SEARCHING WHOLE DATA(WHAT EVER THE MILLIONS OF RECORDS) FROM CUBE FOR CERTAIN DATA ACCORDING TO THE QUERY REQUIREMENT WE GO FOR AGGREGATES.
AND IT'S REDUCE THE NUMBER OF RECORDS WHICH USE AS A SAVING DATA WAREHOUSE SPACE.
AGGREGATES WOULD BE CREATED ACCORDING TO THE FREQUENTLY USING QUERIES.
AND DIS ADVANTAGE OF AGGREGATES :
IF WE MAINTAIN THE AGGREGATES WE WOULD HAVE THE SAME DATA ALSO IN INFO CUBE AS WELL AS AGGREGATES ITS LEADS TO MUCH OCCUPY THE DATABASE SPACE.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the conversion routine for units and currencies in the update rule?
What exactly do you know about the sap bw?
What is business content?
What makes it more advanced than sap business warehouse (sap bw) 7.5?
How do you activate personalization for bex?
List the steps to do the creating classes in sap-bw
What are the different categories of infoobjects in bw system?
Extraction in mm and SD and FI? What is the requirement and name them?
What is the index?
I have a report it taking so much time how can I rectify
Explain the architecture of the sap bw system?
What is the importance of 'start routine' in update rules?
what are the drawbacks of cubes?
What are the options when defining aggregates?
What is compression in the data warehouse?
