What is aggregate awareness?
- 2 Answers
- 6577 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 about Control M JObs detaily?How to execute this.
2 Answers Scope International,
What is the difference between drill through and masterdetail reports?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Name at least three brands of Database Management Systems
What is the difference between snowflake and star schema?
What is data warehouse architecture?
What is up date strategy and what are th options for update strategy?
What are the key features of chameleon that separates it from other algorithms?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is ods (operation data source)?
What is the function of surrogate key in data warehousing?
Teradata 
