I have few questions regarding:

1. What is the Materialized View ; and its applications, Advantages and Dis-Advantages.

2. Whare are Dimensions and its applications, Advantages and Dis-Advantages.

Thanx...