Mumbai University > Information Technology > Sem 5 > Advanced Database Management System

Marks: 5M

Year: Dec 2014

• The snowflake schema represents a dimensional model which is also composed of a central fact table and a set of constituent dimension tables which are further normalized into sub-dimension tables.
• In a snowflake schema implementation, Warehouse Builder uses more than one table or view to store the dimension data.
• Separate …