Interested to Buy Any Domain ? << Click Here >> for more details...
why u go for aggregate? tell me one example?
- 5 Answers
- 17633 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
how bw was found
What exactly do you know about the term data flow in the business intelligence or business warehouse?
Is it possible for the users to convert the package group into a process chain? If so, how?
how to getweekday,weekmonth,month,weekno,week order in the report by using routines?
explain return tables. How do start routine and return table synchronize with each other?
In real world when do you recommend aggregate?
What is the index?
How does it do delta?
What is infoobject otpauth?
What are the different categories of infoobjects in bw system?
What is info provider documentation?
how would you do the unloading non-cumulative cubes.
Give an example of CO-PA fields at the operating concern that are not replicated?
What are the options when defining aggregates?
What does the VARIABLE_SCREEN URL parameter do?
