Interested to Buy Any Domain ? << Click Here >> for more details...
What is aggregate awareness?
- 2 Answers
- 8129 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
aggregate awareness is a function in business objects with
which we can get information from the aggregate tables in
data base
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / learner
Aggregate awreness is the function in BO, which helps in
improving the performance of reporting. For ex. if we have
data at different levels of aggregation in different tables
of a single universe, then this function helps the bo to
select the table(detail table or light aggregated table or
highly aggregated table)(ex year, month,daily revenues in 3
tables) for running the query while creating the report
based on the grain level of reporting requirement.(for
example if we ask year wise revenue then it will directly
go to that year table instead of calculating it from the
daily table).
| Is This Answer Correct ? | 0 Yes | 0 No |
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
How do we design a universe?
Why should you put your data warehouse on a different system than your oltp system?
How can we schedule the graph in unix?
How can we run the graph? How can we schedule the graph in unix?
What is a Data Warehouse?
Explain what is difference between query studio and report studio?
what type of raid setup would you put your tx logs?
What is the difference between datawarehouse and bi?
What are Non-additive facts?
What is called data cleaning?
What is surrogate key? Explain with examples.
Teradata 
