Interested to Buy Any Domain ? << Click Here >> for more details...
why u go for aggregate? tell me one example?
- 5 Answers
- 17609 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
Explain about ods?
what is high cardinality tell me brief
Explain about cubes?
What is the use of navigational attributes?
what is meant by compounding attribute tell me the scenario?
why ods activation fail? What types of fails are there? What are the steps to handle
What is the use of infocube in the bw system?
my intermediate is mpc and my graduation is bcom and pg is mba. learnt sap bw and abap. tell me the interview questions for the same?
What is infoobject otpauth?
What is a dashboard in sap bw?
Give some examples of old LIS and new equivalent LO?
What are the data loading tuning one can do?
What are the data sources supported?
how would you do the unloading non-cumulative cubes.
Can any 1 plz tell me How to identify the missing delta's to run the repair full request,and vat are the extractors used in lo cockpit,if i use filter on condition which 1 will execute first?,
