Hi AllCan any one explain the Aggregate tables and how is that helps in fine tunning the performance, Please give an example not the one which is in PDFs.Appreciate your help.Thanks All

Interview Candidate
Aug 10th, 2006
4
2064

Showing Answers 1 - 4 of 4 Answers

Sravan Gopisetty

Sep 14th, 2006

Hi,
Is that Aggregator Transformation or Aggregator Tables.If it is Aggregator Transformation then it CALCULATES the summery values like SumSAl,AVGSAL,MAXSAL,MINSAL FOR EACH GROUP WISE.FOR EXAMPLE LET TACK SCOTT TABLE THERE WE HAVE 4 DIFFERENT DEPT THERE IT CALCULTES AVGSAL,..........ETC FOR EACH GROUP.IN THIS WE ALSO HAVE A ORDER BY CLAUSE SO THAT WE CAN SORT THE DATA BY DEPT WISE THEN IT CALCULATES THE EXPRESSIONS SO THE PERFORMANCE INCRESESS.

Kumaresh Goplsamy
Profile Answers by Kumaresh Goplsamy

Jul 25th, 2007

Hi,

Aggregate table is a pre defined table.calculate the aggregates and store the values in one table.Instead you ask query to generate aggregate every time you just give reference to the aggregate table.This improves query performance .

---------------------------
Thanks & Regards,
Kumaresh Gopalsamy