Interested to Buy Any Domain ? << Click Here >> for more details...
What is aggregate awareness?
- 2 Answers
- 8116 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 |
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is drilling across?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
if you use oracle sql*loader , how do you transform data with it during loading?
Briefly state different between data ware house & data mart?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Compare ?Data mining? and ?Data Warehousing??
what is parallelism?
What are the steps of implementing data warehousing?
How do you define data block size?
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do
How to design file watch jobs?
Teradata 
