GeekInterview.com
Series: Subject: Topic:
Question: 159 of 394

@aggregate aware function

What is the purpose of @aggregate aware function?
please draw, how you use the @aggregate aware function.
Asked by: senthil0613 | Member Since Nov-2007 | Asked on: Nov 16th, 2007

View all questions by senthil0613   View all answers by senthil0613

Showing Answers 1 - 5 of 5 Answers
subramanyam

Answered On : Nov 17th, 2007

@aggregate aware function is used to increase the query performence by using aggregate tables.

  
Login to rate this answer.
MuthuKumar Sankar

Answered On : Nov 22nd, 2007

This function is user to aggregate the values in ascending order which is present in the class. 

  
Login to rate this answer.

Hithanks. but i need how we use the @ Aggregate function in aggregate table.please send the syntax.please explain with one example.

  
Login to rate this answer.
shilps.verma

Answered On : Nov 23rd, 2007

Lets understand the use of Aggregation first with examples.Information is stored in the datawarehouse in the summarised form.Instead of recording the date and time each time a certain product is sold, the data warehouse could store the quantity each hour, each day or each week.Here, comes the use of aggregation--Primarily for 2 purposes;- To save the storage space DWHs can get large with exponential increase in data. Use of aggregations greatly reduces the space- To improve the performance of BI tools. When queries run faster they take up less processing time and the users get their information back more quickly. Relating these facts to BO now,@Aggregate_Aware is a function which determines which tables to use in SQL generation.(detailed or aggregated ?)@Aggregate_Aware(sum(table1.revenue),sum(table2.revenue))

Yes  1 User has rated as useful.
  
Login to rate this answer.
sheriey

Answered On : Nov 28th, 2007

View all answers by sheriey

The @Aggregate_Aware function allows an object to take advantage of tablescontaining summary data in the database. If your database contains summarytables and you are running queries that return aggregate data, it is quicker to runa Select statement on the columns that contain summary data rather than on thecolumns that contain fact or event data.You can use the @Aggregate_Aware function to set up aggregate awareness ina universe. This process includes a number of other steps which are associatedwith the use of the @Aggregate_Aware function

Yes  1 User has rated as useful.
  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.