Explain what is aggregate table and aggregate fact table ... any examples of both?
Submitted by: AdministratorAggregate 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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online Warehouse Concepts Job Interview Questions And Answers
Top Warehouse Concepts Questions
☺ | What is the difference between ODS and OLTP? |
☺ | Explain Is OLAP databases are called decision support system true/false? |
☺ | Explain What are non-additive facts in detail? |
☺ | Explain What is the difference between OLAP and datawarehosue? |
☺ | What is cubes? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |