DBA > Job Interview Questions > Data Warehousing Interview Questions and Answers

What is aggregate table and aggregate fact table

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is aggregate table and aggregate fact table ... any examples of both?

Aggregate tableĀ contains summarised data. The materialized view are aggregated tables.

for ex in sales we have only date transaction. if we want to create a report like sales by product per year. in such cases we aggregate the dateĀ vales into week_agg, month_agg, quarter_agg, year_agg. to retrive date from this tables we use @aggrtegate function.

(Continued on next question...)

Other Job Interview Questions