Warehouse Concepts Question: Download Questions PDF
Explain what is aggregate table and aggregate fact table ... any examples of both?
Answer:
Aggregate table contains summarized 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.
aggregate table is one of the data transaction function and some time it is create a protect per year.this aggregate value is week agg ,month agg quarter agg function
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.
aggregate table is one of the data transaction function and some time it is create a protect per year.this aggregate value is week agg ,month agg quarter agg function
Download Data Warehouse Concepts Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain What is fact less fact table? where you have used it in your project? | Please explain in detail about type 1, type 2(SCD), type 3? |