What is aggregate awareness?
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 difference between view and materialized view?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What is analytical or analytic mean?
How many repositories can we create in Informatica?
What Oracle features can be used to optimize my Warehouse system?
Define data warehouse?
what are the major three types of modeling used?
0 Answers InfoAxon Technologies,
What are diagrams?
0 Answers InfoAxon Technologies,
What is hash partition?
What is the "junk dimension"? Give with examples?
Difference between cold fusion 5 and cold fusion mx 6?
What is a cube in data warehousing concept?