What is the difference between aggregate table and materialized view?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Warehouse General Interview Questions

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

0 Answers  


Code the tables statement to produce a multi-level frequency?

0 Answers  


Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

0 Answers  


What are the data marts?

0 Answers  


What is the difference between a primary and secondary actor in use case modeling?

0 Answers  






What does level of granularity of a fact table signify?

0 Answers  


What is aggregate awareness?

2 Answers  


How to answer the question how many fakt table in your datawarehouse and what size it have?

3 Answers   Cap Gemini,


What is the data type of the surrogate key?

0 Answers  


What are templates in which way it is help full?

0 Answers  


What are fact, dimension, and measure?

0 Answers  


What is a staging area? Do we need it? What is the purpose of a staging area?

0 Answers  


Categories