INTERVIEW QUESTIONS DATA WAREHOUSING BUSINESS OBJECTS DETAILS

Question: What is aggregate awareness and how can we use it?

Answer: Aggregate awareness function is used to aggregate the values present in the classes in descending order.

for instance we have year,quarter,month,week tables

then we sum the year,sum(quarter),sum(month),sum(week) in decending order respectively.

we also select the compatable as well as incompatible objects through aggregate navigation so that it improves the performance of the system in generating the report.

Aggregate awareness function is used to aggregate the values present in the classes in descending order.

for instance we have year,quarter,month,week tables

then we sum the year,sum(quarter),sum(month),sum(week) in decending order respectively.

we also select the compatable as well as incompatible objects through aggregate navigation so that it improves the performance of the system in generating the report.
Source: CoolInterview.com

Aggregate awareness: This property is defined to the object,when it is available in normal table as well as aggregate table

syntax:@aggregate aware(highest table followed by normal table)
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question