What is the difference between aggregate table and materialized view?

Question Posted / anand singh

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

More Data Warehouse General Interview Questions

Explain difference between e-r modeling and dimentional modeling?

What is the difference between data warehouse and operational systems?

what is difference between drill & scope of analysis?

what is user variable in affinium campaign? and some real time examples.

what are different types of partitioning in oracle ?

Explain what is the advantages data mining over traditional approaches?

What is real-time datawarehousing?

What is the difference between an ODS and a W/H?

What is Molap and Rolap? What is Diff between Them?

How to pivot data using informatica when you have variable amount of pivot rows?

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

Why do we use DSS database for OLAP tools?

For more Data Warehouse General Interview Questions Click Here