Interested to Buy Any Domain ? << Click Here >> for more details...
What is aggregate awareness?
- 2 Answers
- 7887 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 what is a three tier data warehouse?
What is the function of surrogate key in data warehousing?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Which kind of index is preferred in DWH?
what is the difference between etl tool and olap tools
Explain the versions of reportnet?
What is hash partition?
How can we run the graph? How can we schedule the graph in unix?
What is static and local variable?
How do you create surrogate key using ab initio?
What are cursors?
What is a cube in data warehousing concept?
Teradata 
